Referencing Multiple Columns

[jal0315]

I am trying to sum up stock that was received in a given month to each individual location. I can't do a vlookup because the same item might hit multiple locations and not give me the correct quantity received in at that location. I have two separate worksheets. One worksheet is a summary of what was received, and the other is a summary of current on hand inventory with other data.


My sheet of what was received is set up as the following:
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]Location ID[/TD]
[TD]Item ID[/TD]
[TD]Quantity Received[/TD]
[/TR]
[TR]
[TD]100
[/TD]
[TD]ABC[/TD]
[TD]100
[/TD]
[/TR]
[TR]
[TD]111[/TD]
[TD]ABC[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]DEF[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]111[/TD]
[TD]DEF[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]120[/TD]
[TD]GHI[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]300[/TD]
[TD]GHI[/TD]
[TD]60[/TD]
[/TR]
[TR]
[TD]500[/TD]
[TD]GHI[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]500[/TD]
[TD]JKL[/TD]
[TD]20[/TD]
[/TR]
</tbody>[/TABLE]

My inventory overview is set up as the following:
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]Location ID[/TD]
[TD]Item ID[/TD]
[TD]Quantity on Hand[/TD]
[TD]Quantity Received in May[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]ABC[/TD]
[TD]60[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]111[/TD]
[TD]ABC[/TD]
[TD]30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100
[/TD]
[TD]DEF[/TD]
[TD]40
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]111[/TD]
[TD]DEF[/TD]
[TD]30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]120[/TD]
[TD]GHI[/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]300[/TD]
[TD]GHI[/TD]
[TD]60[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]500[/TD]
[TD]GHI[/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]500[/TD]
[TD]JKL[/TD]
[TD]40[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

What formula can I used to reference the Loc ID cell, then the Item ID, and if those match up to give me what was received in during the month from the first worksheet?

 

[Fluff]

Have a look at Sumifs https://exceljet.net/excel-functions/excel-sumifs-function

 

[steve the fish]

I cant see a received date in the first table which means it going to sum whatever it finds regardless of date.

=SUMIFS(Sheet1!C:C,Sheet1!A:A,A2,Sheet1!B:B,B2)

 

[jal0315]

I cant see a received date in the first table which means it going to sum whatever it finds regardless of date.

=SUMIFS(Sheet1!C:C,Sheet1!A:A,A2,Sheet1!B:B,B2)

I've already summed up the quantity received in a pivot table.

 

[steve the fish]

It will still work. Did you not try it?

 

[jal0315]

It will still work. Did you not try it?

i believe it did work Thanks for the help!