Hi all,

I have a workbook that currently has a count up sheet for an instanc
of certain text in a named range, it counts when people have bee
booked off work, my problem is that rather than booking days off in th
future they will be booking either an 8 hour day in one period or a 1
our day in another and have a total 0f 128 hours to book off. I want t
be able to count the amount of hours on my count up sheet for text foun
in the source sheet, so if "Bloggs J" appears in named range "Hols" an
is in between cells A1:A20 then its 8 added to the count up but if i
appears in named range "Hols" between cells A20:A30 it adds 12 to th
count up!?

I can mail you my current workbook so you can see how it all works a
the moment.

Any thoughts?

Simon

P.S i currently use =COUNTIF(Hols,"Bloggs J"

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