Standard deviation to exclude 0

C

cpliu

In our data, 0 means not applicable.
I'm using STDEVP but calculate value 0 too. Can I exclude values with
0?

Maybe I should do search and replace!

Thanks,
 
B

Bernard Liengme

Enter this
=STEVE(IF(E1:E7<>0,E1:E7,""))
as an array function.
That means use CTRL+SHIFT+ENTER when you have done typing; Excel will wrap
the formula in curly braces { ... }
You need to use the same committal it you edit the formula
best wishes
 
C

cpliu

That works. Thanks for the help.
Also this one works too:
=STDEVP(IF(C2:C558=0,"",C2:C558))
 
Top