That would not exclude zero from the average

--


Regards,


Peo Sjoblom


"JBeaucaire" wrote in message
...
Try this:

=SUM(F10,F13,F16,F19,F22,F26,F30) / COUNTA(F10,F13,F16,F19,F22,F26,F30)
--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"Beth Gaines" wrote:

I want to average a group of percentages but want to exlude cells which
have
the value 0 (some of the cells have 0 for the numerator and denominator).
What would the formula be? What I have so far is
=(F10+F13+F16+F19+F22+F26+F30)/7
What I want to do is exclude F19 for example if its value is 0 rather
than
0%. Any suggestions?
Thanks much.