Counting weekend shifts in a sheet


J

John in Wembley

Hi team

I have a roster (they call it a rota here in the UK)

Row A: days along the top, monday to sunday for 28 days.

Row B,C,D staff members & their shifts along each row

How can I count at the end of each row how many saturday/sunday shifts
the staff member has done?
Is Dcounta the way to go?
 
Ad

Advertisements

P

Pete_UK

Do you have something like "Y" to indicate a member of staff allocated
to a particular shift?

If so, try something like this:

=SUMPRODUCT((B2:AC2="Y")*(WEEKDAY(B$1:AC$1,2)>5))

You seem to be a bit confused about rows and columns, but I think this
is what you have - I've assumed a name in column A, and dates in row
1. Copy the formula down for as many staff as you have.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top