average cells, show 0 if nothing to average

Giganews Newsgroups
Subject: average cells, show 0 if nothing to average
Posted by:  Kycajun
Date: Wed, 21 Jun 2006

I am averaging the following:

=AVERAGE(G67:G76), this works fine (simple formula).  However, if nothing is
entered in all of these cells, I would like my results cell to display 0.
Currently if nothing is entered for G67 thru G76, it results in #DIV/0!.  I
just want it to show 0.  I know this is simple, but I am dancing all around
it.  Any suggestions would be appreciated.  Thanks!

Replies