Sums all arguments, divides the result by the number summed, and returns a single result.
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.
=avg($R3F4:R7F6)
=avg($R6F4, $R10F8)
=avg(5, $R6F7)
Copyright © 2004. Sybase Inc. All rights reserved. |
![]() |