Time Sheet Problem

[Nocco]

Hello,
This is my first post so go easy on me.
I'm trying to make a time sheet for work,
I've created a simple formula to add the 7 days
of the weeks hours together
which is as follows
=SUM(F22, F25, F28, F31, F34, F37, F40)
but say on a certain day I have a holiday (HOL)
I'd like it to take this in consideration and
make the formula add the hours up then
add say "+1 DAY HOL" after the hours.
I hope this makes sense.

Cheers for any help.

[VBA Noob]

Maybe

=IF(COUNTIF(F22:F40,"Hol")>=1,SUM(F22,F25,F28,F31,F34,F37,F40)&" Hrs + "&COUNTIF(F22:F40,"Hol")&" DAY HOL",SUM(F22,F25,F28,F31,F34,F37,F40))

VBA Noob

[Nocco]

Maybe

=IF(COUNTIF(F22:F40,"Hol")>=1,SUM(F22,F25,F28,F31,F34,F37,F40)&" Hrs + "&COUNTIF(F22:F40,"Hol")&" DAY HOL",SUM(F22,F25,F28,F31,F34,F37,F40))

VBA Noob

Thank you, I'll try that :D

[Nocco]

Maybe

=IF(COUNTIF(F22:F40,"Hol")>=1,SUM(F22,F25,F28,F31,F34,F37,F40)&" Hrs + "&COUNTIF(F22:F40,"Hol")&" DAY HOL",SUM(F22,F25,F28,F31,F34,F37,F40))

VBA Noob

Thank you, that works fine with 1 persons hours,
but if I try to add this to another persons hours (there are 3 people on this sheet)
it adds the Holidays to the other 2 people's hours.
I've attached the sheet so you can see.
Thanks for anymore help.

Cheers.