Hello Oeldere
About the red value, you just need to format it differently.But that's not a problem.
My answers are not real cose they're just a simulation of an ideal output.
About doing it in a pivot table, i'd love to, but only in excel 2013i can add another table on a previous one. With my excel version of 2010, i don't think i can do it...
About your file, you cannot repeat the cost per hour for each worker because you're going to need to multiply all the hours of each person by his rate (cost/hour)....for all workers.
Tks for your effort anyway. any other ideas?
I'm trying now to build several tables so, with sumifs, i have what i want...but i'm not getting there.
Best regards
PEdro