I would like to know how to make this formula not show #DIV/0! error if there is nothing to average.
=AVERAGE(H86:K86)
Thanks for you expert knowledge and help.
Michelle
I would like to know how to make this formula not show #DIV/0! error if there is nothing to average.
=AVERAGE(H86:K86)
Thanks for you expert knowledge and help.
Michelle
Last edited by leem; 11-24-2010 at 09:18 AM.
If you use XL 2007 (what would be nice to write in your profile) you can use IFERROR formula
=IFERROR(AVERAGE(H86:K86), "")
If you use previous version you can count values first:
=IF(COUNT(H86:K86)>0, AVERAGE(H86:K86), "")
Never use Merged Cells in Excel
Your right, sorry about that, Excel 2003. Thank you for your quick response and solving my problem. I really appreciate it.
Write in the profle please... Nobody will see this post next time you ask a question![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks