JMB, again thanks for replying, i understand the formula you gave and
can see it will work fine for counting instances of the value in
whichever cell the test is in, but in the formula i use
=COUNTIF(Hols1,E2)*8+COUNTIF(Hols2,E2)*12+COUNTIF( Hols3,E2)*8+F2 i
need to multiply each instance by either 8 or 12 depending where it
finds the instance (this is because it is counting up the amount of
hours someone has booked off), i can of course mail you the workbook if
you would like to see what i'm getting at!. I am using excel 2003 and
win xp.

My e-mail address is simonwlloydATmsnDOTcom, if you want to mail me
direct i can send you the workbook by return.

Thanks,

Simon


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