Excel 2007 : Calculating Standard Deviation for certain numbers only

[naifu]

Hi all...

I was wondering, how do you use STDEV so that it only takes into account numbers that aren't equal to zero ( != 0).

For example,

Columns A-H have 7 numbers, 3 of which are 0. How do I use =STDEV so that it only calculates the standard deviation only using the 4 numbers?

Thanks a lot,

[DonkeyOte]

You can use an Array

Please Login or Register  to view this content.