Excel DIV/O

I know how to put a formula into a cell to change the above reference error
message to reflect zero, however is there a way to do it with a range. Such
as
=if(H11:H18=0,"",(average(h11:H18

Thanks

I'm not sure what you are asking exactly but I typically use something like:
=IFERROR(AVERAGE(H11:H18),0)

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Co-author of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/boo...x#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

"Beep Beep" wrote in message
...
I know how to put a formula into a cell to change the above reference error
message to reflect zero, however is there a way to do it with a range.
Such
as
=if(H11:H18=0,"",(average(h11:H18

Thanks