K
Kolyan
Hi all,
I need STDEV formula to ignore zeros.
Thanks for your help!
Kolyan
I need STDEV formula to ignore zeros.
Thanks for your help!
Kolyan
K
keepITcool
=STDEV(IF(A1
1>0,A11,""))
enter as ARRAYformula with ctrl-shift enter
keepITcool
< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
1>0,A11,""))enter as ARRAYformula with ctrl-shift enter
keepITcool
< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
K
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
KeepITcool, thanks a lot!
I will use it but just wondering if there is a non-array
formula as well?
Thanks again,
Kolyan
H
hgrove
Kolyan wrote...
...
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.
...
...
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(--(A1
1>0),(A11-SUMIF(A11,">0")/COUNTIF(A1
1,">0"))^2)/(COUNTIF(A11,">0")-1))^0.