Hi, I have a spreadsheet that has 2 tabs. The first tab is just an overall dept. Summary tab to ideally give hour totals and dollar totals based on information that is pasted weekly in the second tab. The headers in the first tab look like this:
They are only looking for hours for the Warehouse workers but they do want dollars for them and everyone else.
Tab two contains several different headers, but the ones relevant to here would be Earn Code (REG, Overtime, etc.), Hours Amount, Dollar Amount, and Position description
Here is where it gets a little tricky. Maintenance encompasses several positions, Battery Persons, Refrigeration Technicians, General Maintenance, and Parts Clerks, but they are all to be reported under one total - maintenance.
My question is can there be some kind of formula on tab 1 that will encompass the hour totals and dollar totals, and lump together what positions are within one department. What would be the best way to do this?
A | B | C | |
1 | Dept Type | HOURS | Dollars |
2 | Warehouse Worker Regular | ||
3 | Warehouse Worker Overtime | ||
4 | Maintenance | N/A | |
5 | Transportation | N/A | |
6 | Mechanics | N/A | |
7 | Warehouse Clerks | N/A | |
8 | Inventory Clerks | N/A |
They are only looking for hours for the Warehouse workers but they do want dollars for them and everyone else.
Tab two contains several different headers, but the ones relevant to here would be Earn Code (REG, Overtime, etc.), Hours Amount, Dollar Amount, and Position description
Here is where it gets a little tricky. Maintenance encompasses several positions, Battery Persons, Refrigeration Technicians, General Maintenance, and Parts Clerks, but they are all to be reported under one total - maintenance.
My question is can there be some kind of formula on tab 1 that will encompass the hour totals and dollar totals, and lump together what positions are within one department. What would be the best way to do this?