G
Guest
Dearest Wizards,
Typical work schedule here. Employee’s names in Col A, Dates of a 4 week
period on Row 1.
What I want: Row 2 to have the number of WORKING employees on for that day.
Why this is becoming complicated: Below the schedule grid is another two
tables. One table has codes that go in the schedule grid that indicate
WORKING employees i.e. “1†for lead worker, “T†for working the table, “FLâ€
for working the floor etc. These codes would be in a column, say from B100
to B199. The other table has codes for NON-WORKING employees i.e. “v†for
vacation, “m†for meeting, “FM†for FMLA etc. These codes would be in a
column, say from B250 to B349.
I’d like to avoid a countif+countif+countif situation because I anticipate
adding other codes as the years go by. Isn’t there a formula I can use in
row 2 that will reference the ‘working codes’ column that will give me a
count of just the actual working employees for that day?
TIA for your assistance.
Sam Beardsley
Typical work schedule here. Employee’s names in Col A, Dates of a 4 week
period on Row 1.
What I want: Row 2 to have the number of WORKING employees on for that day.
Why this is becoming complicated: Below the schedule grid is another two
tables. One table has codes that go in the schedule grid that indicate
WORKING employees i.e. “1†for lead worker, “T†for working the table, “FLâ€
for working the floor etc. These codes would be in a column, say from B100
to B199. The other table has codes for NON-WORKING employees i.e. “v†for
vacation, “m†for meeting, “FM†for FMLA etc. These codes would be in a
column, say from B250 to B349.
I’d like to avoid a countif+countif+countif situation because I anticipate
adding other codes as the years go by. Isn’t there a formula I can use in
row 2 that will reference the ‘working codes’ column that will give me a
count of just the actual working employees for that day?
TIA for your assistance.
Sam Beardsley