Forum Discussion
Find duplicates in a range and match corresponding values
Good morning all, Each Dept. generates different revenue per hour of work. My end goal is to calculate the revenue generated per person per hour worked by weighting each person's revenue per h...
Hi Joseph,
You may use SUMIFS().
To generate list of departments for the person (cell G4)
=IFERROR(INDEX($B$4:$B$13,AGGREGATE(15,6,1/($A$4:$A$13=$F$4)*ROW($A$4:$A$13),COLUMN(A:A))-ROW($A$3)),"")
To sum hours (cell G5)
=SUMIFS($C$4:$C$13,$A$4:$A$13,$F$4,$B$4:$B$13,G$4)
and attached