View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PJS PJS is offline
external usenet poster
 
Posts: 23
Default Calculating STDEV for non zeroes

Hi to whom might be of assistance

I am trying to calculate the Standard Deviation for a set of data while
excluding zeroes. Ley say, I have the following data set

1, 2, 3, 4, 5, 0
2, 1, 3, 0, 5, 4
0, 2, 4, 6, 8, 10

I can calculate the average of the first line of data by sum(A1:F1) /
countif(A1:F1)
but I am not sure how to calculate the STDEV while excluding the zeros where
ever it may be.

Is there a way to do so?

Thanks,

PJS