Split Cost based on each project worked

[odoolead1]

Hello Team,
I want to split employee wages based on the hours worked on each project. I have attached a sample data with desired output (Desired Output in Yellow )


Thanks for all you help

 

[pecoflyer]

In E3 and pulled down as needed

=VLOOKUP($B3,$H$3:$I$6,2,0)*($D3/SUMPRODUCT(--($B$3:$B$32=$B3)*$D$3:$D$32))

 

[odoolead1]

In E3 and pulled down as needed

=VLOOKUP($B3,$H$3:$I$6,2,0)*($D3/SUMPRODUCT(--($B$3:$B$32=$B3)*$D$3:$D$32))

Thanks pecoflyer. That worked.

Really appreciate your help.

 

[odoolead1]

Thanks pecoflyer. That worked.

Really appreciate your help.

Hey pecoflyer.
What if I have to include the empid as a criteria to get the result.

Thanks for your help.

 

[pecoflyer]

Do you need EmpId AND Name or only EmpId?

 

[odoolead1]

Do you need EmpId AND Name or only EmpId?

Hey pecoflyer,
Sorry for delayed response. Yes both EmpId and Name..

Again sorry for delayed reponse.

Thanks for your help.

 

[pecoflyer]

Using XLOOKUP

=XLOOKUP(1,($I$3:$I$6=$A3)*($J$3:$J$6=$B3),$K$3:$K$6)*($D3/SUMPRODUCT(--($B$3:$B$32=$B3)*($A$3:$A$32=$A3)*$D$3:$D$32))

 

[odoolead1]

Using XLOOKUP

=XLOOKUP(1,($I$3:$I$6=$A3)*($J$3:$J$6=$B3),$K$3:$K$6)*($D3/SUMPRODUCT(--($B$3:$B$32=$B3)*($A$3:$A$32=$A3)*$D$3:$D$32))

Hello pecoflyer,
Really appreciate your help Sir.

 

[Monty]

Hello pecoflyer,
Really appreciate your help Sir.

May be the shortest one to work with

=SUMIFS($K$3:$K$6, $I$3:$I$6, $A3, $J$3:$J$6, $B3) * ($D3 / SUMIFS($D$3:$D$32, $B$3:$B$32, $B3, $A$3:$A$32, $A3))

 

[vletm]

odoolead1​

Your I want to split employee wages based on the hours worked on each project.
Isn't Your want then something like below?
... on each project

 

[odoolead1]

odoolead1​

Your I want to split employee wages based on the hours worked on each project.
Isn't Your want then something like below?
... on each project
View attachment 86670

Yes Sir, you are right. I didnt group it. Looks like I am getting same numbers.

Thanks for your time and effort