STDEV function on selected values
 

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:C340)*(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

STDEV function on selected values
 

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

Jerry

"Tetsuya Oguma" wrote:

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:C340)*(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