I have a spread sheet where I show the days of the week in one line Monday
thru Sunday B3 thru H3, below that line, I show what the employee is supposed
to work B4 thru H4 , the line following that I insert what the employee
actually worked B5 thru H5. This work schedule if built for a six week time
period.

Now at the bottom, I have a formula =COUNTIF(B2:O170,"REST") which counts
all the days in which the employee showed off rest. When I put the work
sheet together, I never thought about it counting the assigned rest days.

Question,, in the calculation, can I have it not count what is in lines 3
and 4, just add what is on line 5. This would be the same for the next week,
not count lines 6 and 7, but pick up the rest days on line 8, so forth for 6
months, or just count what is on every other 3rd line.


--
DLAYMANS