Standard deviation to exclude 0

  • Thread starter Thread starter cpliu
  • Start date Start date
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,
 
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
 
That works. Thanks for the help.
Also this one works too:
=STDEVP(IF(C2:C558=0,"",C2:C558))
 
Back
Top