sum  int

Chapter 1: Developer Features

avg

Description

Sums all arguments, divides the result by the number summed, and returns a single result.

Arguments

There can be one or more array arguments. Summation is carried across all the arrays specified (or, if scalars, by simply adding the scalar value to the current summation). Non-numeric values are ignored (and not added to the count of items summed). The result is returned as a floating point value.

Examples

=avg($R3F4:R7F6)
=avg($R6F4, $R10F8)
=avg(5, $R6F7)




Copyright © 2004. Sybase Inc. All rights reserved. int

View this book as PDF