 Formula Engine Reference Guide |
|
Back to Class Index
CSTDS(argumentlist, C)
Returns the sample standard deviation (N-1 weighting) of its arguments which satisfy the constraint C. Blank cells and cells containing strings are not counted.
Parameters
argumentlist
Any combination of cells or ranges
C
A constraint expression
Examples
CSTDS(A1..A3, #<10) = 3.2145503
where A1..A3 are 1, 2, and 7
CSTDS(Y1..Y5, #25) = 8.1853528
where Y1..Y5 = 22, 24, 29, 34, and 45