SUMIF And INDEX_MATCH

[Don Adeks]

Dear Team,

Kindly help fine-tune my formula in the attached.

I know how to use index/match very well with multiple criteria, but because each loc code has different quantities of the same item code, i want to add SUMIF, so that the output will be a sum of a particular item code present in a particular location.

My expected result is also there, all I need is a little tweak on how to get there.

Thanks in anticipation.

Don Adeks.

[jason.b75]

No index needed, try this in Sheet2 B3

=SUMIFS(Sheet1!$C:$C,Sheet1!$A:$A,$A3,Sheet1!$B:$B,B$2)

Then drag to the rest of the table.

[Don Adeks]

Hello Jason.b75,

Thanks a lot. It worked and I am so grateful to you.