cjbrooks723
New Member
- Joined
- Sep 4, 2015
- Messages
- 1
I'm having a terrible time figuring this one out.
Column B is Date of Training
Column D is the trainee name
Column F is the instructor name (there are two)
Column I is the number of hours of training received by the trainee on that date
I need a formula that counts the number of hours each trainer spent training by month.
The issue I am encountering is that there are multiple trainee names for each date, as well as a potential different number of hours on any given day. So, for instance, if on January 5th, there are 8 trainees who each received 8 hours of training apiece, that is a total of 64 employee training hours, but only 8 hours performed by the trainer. I've not been able to get the correct amounts using a pivot table so far. Averages are not working either. I know there has to be a countif combo that would work here. Any ideas?
Column B is Date of Training
Column D is the trainee name
Column F is the instructor name (there are two)
Column I is the number of hours of training received by the trainee on that date
I need a formula that counts the number of hours each trainer spent training by month.
The issue I am encountering is that there are multiple trainee names for each date, as well as a potential different number of hours on any given day. So, for instance, if on January 5th, there are 8 trainees who each received 8 hours of training apiece, that is a total of 64 employee training hours, but only 8 hours performed by the trainer. I've not been able to get the correct amounts using a pivot table so far. Averages are not working either. I know there has to be a countif combo that would work here. Any ideas?
