Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting weekend shifts in a sheet
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting weekend shifts in a sheet
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 On Jan 29, 7:59*pm, John in Wembley wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Table of employees and shifts | Excel Worksheet Functions | |||
End of month help with shifts | Excel Worksheet Functions | |||
Print Area Shifts | Excel Discussion (Misc queries) | |||
More column shifts ... | Excel Discussion (Misc queries) | |||
Set up schedule for 3 different shifts | Excel Discussion (Misc queries) |