STDEV function on selected values

[Tetsuya Oguma]

Hi all,

I am wondering one groovy function that

1. Selects values according to my criteria, such as more than 0 (zero) AND
less than 5000, and
2. Take standard deviation of the selected values.

I know a function like "=SUMPRODUCT((C4:C34>0)*(C4:C34<5000))" counts the
values that are more than 0 and less than 5000 in the range of Cell C4:C34,
but not appropriate for my purpose.

So, how can I do that bit and enclose it in =STDEV() function?

Thanks!
Tetsuya Oguma, Singapore

 

[Jerry W. Lewis]

=STDEV(IF((C4:C34>0)*(C4:C34<5000),C4:C34))
array entered (Ctrl-Shift-Enter)

Jerry