CAVG(<List>, C)

 

Description

This function returns the arithmetic mean of the arguments that satisfy the constraint C.  Blank cells and strings are ignored.

 

Parameters

 

<List>

Any combination of cells or ranges.

 

C

A constraint expression.

 

Examples

 

CAVG(A1:A5, #<6) = 2.333333

Where A1:A5 is 2, 2, 3, 6, and 7.