CVAR

**Syntax:** **CVAR( argumentlist, C)**

*argumentlist* = any combination of cells or ranges

*C* = a constraint expression

**CVAR** returns the population variance (N weighting) of
its arguments which satisfy the constraint *C*. Blank
cells and cells containing strings are not included.

**Examples:**

**CVAR**(Y1..Y5, #25) = 1, where Y1..Y5 = 22, 24, 29, 34,
and 45

**CVAR**(A1..A3, #C2*E7) = 6.8888889, where A1..A3 are 1, 2,
7, and C2 = 5 and E7 = 2

**Excel function:** *N/A*

Grey Trout Software

02 March 2003