Calculating Standard Deviation while ignoring Zeros
Thanks for your help everyone.
Tom Ogilvy wrote:
=stdev(if(A1:A100=0,false,A1:A100))
Entered with Ctrl+Shift+Enter rather than just enter since this is an array
formula.
--
Regards,
Tom Ogilvy
wrote in message
oups.com...
I am working with a large data set and I am interested in calculating
standard deviation of over 100 samples, but I want to ignore any zero
values and only utilize the non-zero values in the calculation. Does
anyone know an easy way to do this. Thanks for the help.
Mike
|