Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complicated cell counts
Dearest Wizards,
Typical work schedule here. Employees 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. Id like to avoid a countif+countif+countif situation because I anticipate adding other codes as the years go by. Isnt 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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complicated cell counts
Maybe this.....
=COUNTA(B100:B199) Vaya con Dios, Chuck, CABGx3 "Metolius Dad" wrote: Dearest Wizards, Typical work schedule here. Employees 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. Id like to avoid a countif+countif+countif situation because I anticipate adding other codes as the years go by. Isnt 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert date | Excel Worksheet Functions | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
copying cell names | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel |