How do I average a formula without calculating zero values?

K

KMHarpe

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

Thanks!
 
B

Bob Phillips

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

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