CSTDS(<List>, C) |
![]() ![]() ![]() |
Description
This function returns the sample standard deviation (N-1 weighting) of its arguments that satisfy the constraint C. Blank cells and cells containing strings are ignored.
Parameters
<List>
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.
Try Predictive Systems Lab
Need Help?
Contact support