Hi Guys,
So I am having a problem. I am trying to create an inventory system where I can look up the same item with different quantities and add those quantities together on a separate spreadsheet.

Example.

Spreadsheet 1
Item info: Location Manufacture N: Quantity: Link:
Apples - CA - 45231 - 2
Bananas - CA - 6421 - 4
Pears - NY - 5648 - 2
Apples - CA - 45484 - 6
Apples - NY - 5648 - 3

Spreadsheet 2
Should pull all Item Info and Location plus Quantity (calculated) and the quantities and add them together

Item Info Location quantity
Apples - CA - 8
Apples - NY - 3
Bananas - CA - 4
Pears - CA - 2



If someone can help me with the formula for this that would be great Thank You