Simon,
Try this:

=COUNTIF(Hols1,"Bloggs J")*8+COUNTIF(Hols2,"Bloggs J")*12

HTH

"Simon Lloyd" wrote:


Sorted the only counting by one, but can not get it to also add on the
12hr periods in the second named range!

Can anyone sort this muddle out please?

Simon

=IF(COUNTIF(Hols1,"Bloggs J"),COUNTIF(Hols1,"Bloggs
J")*8,AND(COUNTIF(Hols2,"Bloggs J"),COUNTIF(Hols2,"Bloggs J")*12,0))


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=390844