next up previous contents index
Next: CCOUNT Up: A. Function Reference Previous: AVG, AVERAGE   Contents   Index


CAVG

Syntax: CAVG(argumentlist, C)

argumentlist = any combination of cells or ranges
C = a constraint expression

CAVG returns the average (arithmetic mean) of those arguments which satisfy the constraint C. Blank cells and strings are ignored.

Examples:

CAVG(A1..A5, #$<$6) = 2.333333, where A1..A5 are 2, 2, 3, 6, and 7

CAVG(E1..E3, #$>$10) = Error - CAVG, sample size less than 1, where E1 = 1, E2 = 5, and E3 = 0

CAVG(B7..E10, #$<$#-1) = 15, where the average of the numbers in range B7..E10 which are less than the value of the cell to their left is 15.

Excel function: N/A


next up previous contents index
Next: CCOUNT Up: A. Function Reference Previous: AVG, AVERAGE   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003