Hi,

I cant seem to get the correct formula for a sumif with index match on the below.

I want to return the total values in Column B13:B23 in the table above in each Column with a match on both eg Payroll 1 Employee 1 etc

Been trying different ways but dont seem to be able to get the result needed.

Can anyone please assist?

A1 B1 C1 D1 E1 F1 G1
A2 Employee 1 Employee 2 Employee 3 Employee 4 Employee 5
A3 Payroll 1 230
A4 Payroll 2
A5 Payroll 3
A6 Payroll 4
A7 Payroll 5
A8 Payroll 6
A9 Payroll 7
A10
A11
A12 Amount Employee Code Cost Code
A13 150 Employee 1 Payroll 1
A14 200 Employee 2 Payroll 7
A15 50 Employee 4 Payroll 3
A16 20 Employee 4 Payroll 1
A17 80 Employee 1 Payroll 1
A18 600 Employee 1 Payroll 2
A19 700 Employee 3 Payroll 4
A20 100 Employee 3 Payroll 4
A21 450 Employee 4 Payroll 3
A22 250 Employee 5 Payroll 3
A23 100 Employee 2 Payroll 2