Error
Another way:
=IF(COUNT(F43:G43)<0,AVERAGE(F43:G43),"")
Paul, I am fascinated by COUNT() so I try to use COUNT(). If you see a problem, please let me know. Trying to learn here.
Epinn
"Paul B" wrote in message ...
Ken, here is one way,
=IF(ISERROR(AVERAGE(F43:G43)),"",AVERAGE(F43:G43))
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Ken Grady" wrote in message
...
Hi All,
I have a formula that gives the correct result but has an error in the
cell
before any data has been entered into the other cells.
Formula: =AVERAGE(F43:G43)
Error: #DIV/0!
How can I eliminate this error please.
Thank you for your assistance.
Ken.
|