Schedule to count multiple lines and columns to meet two criteria

Hi all,

I have been looking all over the site for a solution to this problem. I have excel 2010.

The page is set up to look like a calendar with each day containing 7 shifts, the last row in each day is to notify if that day is a holiday(which would count as a point and a half). I can't get the formulas to calculate the following count if B11:H11 = 'HOLIDAY' AND B4:H11 = NAME '(ie. D:59)'. Is this possible?

No, That counted the cells if they equaled holiday only. Not if they equaled holiday and employee.

This is the only formula that I found worked. It allowed me to determine my two if statements if one or both equals zero it would count that day to be 0.

=(COUNTIF($B4:$B11,D58)*COUNTIF($B11,$A$66)

I appreciate the help. If you have something that would simplify this then that could be helpful.

Thanks,

G

Schedule.xlsx

Please see attached file. This gives me the result I'm looking for. Since mark isn't on the day marked holiday, he doesn't get counted for working on a holiday. where as steve and john both worked on a holiday and it gave them a result of "1". The main problem(or should I say inconvenience), is that the formula is so long.