Solution Needed

[North for Short]

I am revive this query as I want to do it for myself. Here I have a duty roster for a ficticious parcel company and on the left hand side you the duty number, duty name amd the duty holder. On certain days, the duty holder is having a day off, so a reserve is used (vicky snow). On certain days you can see that Paddy Murphy is not in on Monday and Andrew McDougal is off on Saturday.
On the right hand side is a spread sheet with the criteria that counts the number of John Smith in a Column (there is a conditional format being used when a duty is not covered but Vicky is covering John Smith on Tuesday so it has been included with the count (weekly count is 5, I want 6 across the week). I am not sure if countif (s) is the right function or should an if function be included. I am asking can it first of all be done. So when I insert a name for instance Paddy Murphy on Monday is covered by Vicky on overtime. It will still show 4 but the duty is now covered. How can I show using a function to tell me that the duty is covered.

 

[Joe4]

Duplicate to: Is it a Countif I need

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.