How do I average a formula without calculating zero values?
 

I want to average a column, except for the cells that have zero as a value.
How do I do this?

Thanks!

=AVERAGE(IF(rng<0,rng))

which is an array formula so commit with Ctrl-Shift-Enter.

--
HTH

Bob Phillips

"KMHarpe" wrote in message
...
I want to average a column, except for the cells that have zero as a
value.
How do I do this?

Thanks!