imapoboy2
New member
- Joined
- Jul 2, 2013
- Messages
- 12
- Reaction score
- 0
- Points
- 1
- Age
- 56
- Location
- Wisconsin
- Excel Version(s)
- 2013
I maintain an Excel document of Maintenance Work Orders performed by our technicians. Each line is an individual work order that shows the assigned technician in column "D" and the labor hours used in column "H".
It becomes a very long list by the end of the Fiscal Year. My predecessor would go through each page with a calculator and tally up labor hours for each technician.
I am asking for some help in creating a formula that will sum up the labor hours by technician.
i.e.
A28= the sum of Labor Hours from column "H" that only have the technician "Smith" listed in Column "D".
A29= the sum of Labor Hours from column "H" that only have the technician "Johnson" listed in Column "D".
A30= the sum of Labor Hours from column "H" that only have the technician "Brown" listed in Column "D".
I hope this makes sense... Please help, I don't want to use the calculator.
It becomes a very long list by the end of the Fiscal Year. My predecessor would go through each page with a calculator and tally up labor hours for each technician.
I am asking for some help in creating a formula that will sum up the labor hours by technician.
i.e.
A28= the sum of Labor Hours from column "H" that only have the technician "Smith" listed in Column "D".
A29= the sum of Labor Hours from column "H" that only have the technician "Johnson" listed in Column "D".
A30= the sum of Labor Hours from column "H" that only have the technician "Brown" listed in Column "D".
I hope this makes sense... Please help, I don't want to use the calculator.