All sorted now thanks to Toppers!
=COUNTIF(Hols1,"Bloggs J")*8+COUNTIF(Hols2,"Bloggs J")*1
--
Simon Lloy
-----------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.excelforum.com/member.php...nfo&userid=670
View this thread:
http://www.excelforum.com/showthread.php?threadid=39090