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*

Grey Trout Software

02 March 2003