Standard deviation to exclude 0

[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,

 

[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

 

[cpliu]

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