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