If your cells' results are produced by formulas

=if(formlua=0,"",formula)

then just use the average formula.

--
Regards,
Tom Ogilvy



Sherie wrote in message
...
I am not a programmer but need to write a formula that
will compute an average from a column but without the
zeros.
Or I need the zeros to become an empty cell through a
formula.
I have been researching this for hours and have come up
blank.
Thanks for all help
Sherie