Hi All

I am creating a worksheet which will monitor the performance of a
manufacturing machine each week. The machine is generally used Monday
to Friday but can also be used on Saturdays and/or Sundays. As a
result, some of the formulas that I am using, particularly those for
averages, show up as #DIV/0 because there is no data for that day but I
have to allow for there possibly being values some weeks. Is there a
way that I can replace all #DIV/0's with an actual zero (0) and this
way I can then use an array formula to calculate the average where the
cell value is greater than 0.

Thanks

Shirley Munro:)


--
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