Hi Chip
Thanks for the reply but this doesn't work either. The problem is that
the cell range does not contain zero's, it contains #DIV/0's therefore
the if part of the statement doesn't work and I just get another #DIV/0
error. I need to replace the #DIV/0 errors with zeros and then I can
use an array formula to calculate the average but I don't know how to
replace the #DIV/0's with actual 0's.
I am attaching a screen shot showing the formulas. In this instance it
is Saturday that has a #DIV/0 error since no hours were worked on this
particular week but I have to allow for Saturday and/or Sunday being
worked some weeks.
Any further help would be much appreciated.
Shirley
+-------------------------------------------------------------------+
|Filename: DivZero.jpg |
|Download:
http://www.excelforum.com/attachment.php?postid=4392 |
+-------------------------------------------------------------------+
--
Shirley Munro
------------------------------------------------------------------------
Shirley Munro's Profile:
http://www.excelforum.com/member.php...nfo&userid=836
View this thread:
http://www.excelforum.com/showthread...hreadid=515252