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" <[email protected]> wrote in message
news:[email protected]...
> I want to average a column, except for the cells that have zero as a
value.
> How do I do this?
>
> Thanks!