Nested if statement problem!

[Simon Lloyd]

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

All sorted now thanks to Toppers!

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