Formula help required

I am trying to keep a tally of shifts in an excel staff roster. I’m having trouble finding a formula that works (just a novice user). Basically we want to be able to keep a tally of the following:

– How many saturdays the staff member has worked (7am or 3pm)

– How many sundays the staff member has worked (7am or 3pm)

– How many public holidays have they worked

 

All Sat and Sun shifts are filled with orange and all public holidays are filled with blue. I thought I could use this colour system somehow, but no luck so far. I’ve attached an example of what the roster does look like.

 







  PH SUN MON TUE WED THUR FRI SAT SUN MON TUE WED THUR FRI SAT
BOB SMITH 7 rd rd 7 3 3 7 RD 3 3 3 3 3 RD 7
Karen smith 3 3 3 3 rd rd 7 7 7 7 7 rd 3 3 rd

 

By: Susanna

Leave a Reply

Your email address will not be published. Required fields are marked *