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?