Vlookup and sumifs or pivot table?

hi guys
Here's a tuff one
My clients pays me a fee every month for the service i provide to them.
I have several teams who are working on its project.
Each person has a cost per hour.
If i have total hours worked for each person on each client, knowing what is his cost per month for workers and clients, i may know if i'm charging too much or too litle for each client, right?

That's what i wanna know.

I have my database with how many hours for each person worked on each client. Each person has a monthly hour cost as well as each client.

To obtain the final output that i want, see file attach please, what's your best choice to solve this?

Best regards
Pedro

Hello siva
It refers to the ideal output, i mean, it show us how many euros you spent with each company. How do you obtain that result? You have to know how many hours each worker did and what is is cost per hour. The numbers 100.00€, -150.00€ and 120.00€ are not real, just a number.
Hope my inglish was correct.
Best regards
Pedro

Hello Richard

It refers to the ideal output, i mean, it show us how many euros you spent with each company. How do you obtain that result? You have to know how many hours each worker did and what is is cost per hour. The numbers 100.00€, -150.00€ and 120.00€ are not real, just a number.
Hope my inglish was correct.
Best regards
Pedro

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

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

Hi nflsales
None are working so far...
Tks for your interest
Pedro

Hi nflsales
YES!!! It's working!!!
Tks a lot!!
Best regards
Pedro

Hi nflsales
I've use your formula and...with my file, it's not working. Is that because it's a long file (20.000 rec's)? All data are in the same sheet.
I think my problem is with parentisis.
Can you please check the file attach (livro2.xls). The formula beside Valor should give us 39,92€.
Tks a lot for your time
Best regards