DSTD

Syntax:

DSTD(range, condition)

Returns the sample standard deviation of the contents of the cells in the range for which the condition is satisfied. This is the square root of the sample variance of those cells.

The formula used is:

√( (n·Σi=n (xi2) − (Σi=n xi)2) ÷ (n·(n-1)) )

where xi is each value and n is the number of values.

Example:

DSTD(A1:A15, B1:B15>0)

returns the standard deviation of the contents of the cells in the range A1 to A15 whose equivalent in the range B1 to B15 is greater than zero.

See DAVG for more examples of how to use the condition to control which cells are included.