Syntax: CVARS(argumentlist, C)
argumentlist = any combination of cells or ranges
C = a constraint expression
CVARS returns the sample variance (N-1 weighting) of its arguments which satisfy the constraint C. Blank cells and cells containing strings are not included.
Examples:
CVARS(Y1..Y5, #
25) = 2, where Y1..Y5 = 22, 24, 29, 34,
and 45
CVARS(A1..A3, #C2*E7) = 10.333333, where A1..A3 are 1,
2, 7, and C2 = 5 and E7 = 2
Excel function: N/A