neditheg
07-16-2012, 06:01 AM
Hello guys!
I've attached an excel file to make this easier.
I'm using this file to centralize training hours for each employee.
There are many projects which can be chosen from a drop down list.
For example I have
Ababei Marilena who has on 1st January 5 hours training on 800casa project, 3 hours training on Ass. Voce T. project the next day, then on 3rd of January she has 3 hours of training on 800casa and Wednesday 4th January she has 2 hours on Ass. Mail T. project.
In the second sheet I want to get the total hours of training for my employees grouped by project. I need a formula to make this. I've thought about an sum(if ..statement but I didn't got the right results.
thanks!
I've attached an excel file to make this easier.
I'm using this file to centralize training hours for each employee.
There are many projects which can be chosen from a drop down list.
For example I have
Ababei Marilena who has on 1st January 5 hours training on 800casa project, 3 hours training on Ass. Voce T. project the next day, then on 3rd of January she has 3 hours of training on 800casa and Wednesday 4th January she has 2 hours on Ass. Mail T. project.
In the second sheet I want to get the total hours of training for my employees grouped by project. I need a formula to make this. I've thought about an sum(if ..statement but I didn't got the right results.
thanks!