Hi Dave,

Thanks for the help! I have fixed up the cell ranges as suggested and I
now get 0 as the result (Not as bad as #NUM!). I have made sure that the
cell ranges are correct and that the conditions that I am checking
against actually exist in Sheet1 but to no avail.

I will do some more testing and report back.

Thanks mate
Garry


--
Gazzr
------------------------------------------------------------------------
Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075
View this thread: http://www.excelforum.com/showthread...hreadid=557152