STDEV

[Kolyan]

Hi all,

I need STDEV formula to ignore zeros.

Thanks for your help!

Kolyan

 

[keepITcool]

=STDEV(IF(A11>0,A11,""))
enter as ARRAYformula with ctrl-shift enter

keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

 

[Kolyan]

Great!
KeepITcool, thanks a lot!

I will use it but just wondering if there is a non-array
formula as well?

Thanks again,
Kolyan

 

[hgrove]

Kolyan wrote...
...

I will use it but just wondering if there is a non-array
formula as well?

...

Yes, but it's so much longer and so much less efficient than the arra
formula that it just doesn't make sense to use it.

=(SUMPRODUCT(--(A11>0),(A11-SUMIF(A11,">0")
/COUNTIF(A11,">0"))^2)/(COUNTIF(A11,">0")-1))^0.