sumif many areas

[chris leest]

i have to work out pay for many people on an hourly rate, up to 3 people over 3 job sites or 2 on 2 sites etc
so have employee name , rate of pay and hours in h,i, and j colums and need to total for each day for each person (somtimes one person will do 2 jobs in 2 location. i have tried sum if and works for looking up one person one job but not same person over multipal jobs

so H colum has drop down list of names, I has rate of pay per hour and J has pay ( hours from other location)
then K has drip doen names, L rate of pay and L pay and then repeted again

need to be able to lookin all 3 colums of names and add up all pay fro one person over the 3 sets of incomes......


many thanks

 

[AlanY]

like this?

Excel 2013/2016
	H	I	J	K	L	M	N	O	P	Q	R	S
1	Name	Rate	Hour	Name	Rate	Hour	Name	Rate	Hour		Name	Pay
2	Name1	5.5	8.5	Name4	8.5	8	Name2	5	6.5		Name3	278
3	Name3	6.5	8	Name2	7	8	Name2	9.5	8.5
4	Name1	5	5	Name2	10	7.5	Name1	9.5	6
5	Name2	9.5	7.5	Name5	5.5	5	Name3	5	5
6	Name3	10	6.5	Name4	5	5	Name5	5	6
7	Name4	5	6.5	Name2	10	7.5	Name1	9	6.5
8	Name3	5	9	Name2	9.5	8	Name4	5	7.5
9	Name2	9	6.5	Name3	5.5	7	Name1	10	5
10	Name5	7	8.5	Name5	9	8	Name4	9.5	7.5
11	Name5	6	5.5	Name2	5.5	8	Name3	7.5	7
Sheet1

Cell Formulas
Range	Formula
S2	=SUMPRODUCT(($H$2:$H$11=$R$2)*I2:I11,J2:J11) +SUMPRODUCT(($K$2:$K$11=$R$2)*L2:L11,M2:M11) +SUMPRODUCT(($N$2:$N$11=$R$2)*O2:O11,P2:P11)

 

[Jonmo1]

Also
=SUMPRODUCT(--($H$2:$N$11=$R2),$I$2:$O$11,$J$2:$P$11)