 Formula Engine Reference Guide |
|
Back to Class Index
CAVG(argumentlist, C)
This function returns the average (arithmetic mean) of those arguments that satisfy the constraint C. Blank cells and strings are ignored.
Parameters
argumentlist
Any combination of cells or ranges
C
A constraint expression
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
for the range B7..E10, the average of the numbers that are less than the value of the cell to their left is 15.