Nested if statement problem!
 

Hi i have been given a nested if statement by Aaron as below and
modified it to the bottom statement so that it accumilates 8hrs ever
instance it finds in a named range however the only part that works i
the first section for 8hours but not the latter for 12 hours, can yo
help?

Thanks!

Simon

IF(COUNTIF(Hols1,"Bloggs J"),COUNTIF(Hols1,"Blogg
J")+8,IF(COUNTIF(Hols2,"Bloggs J"),COUNTIF(Hols1,"Bloggs J")+12,0))

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

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

Nested if statement problem!
 

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