I believe I have the same issue... I am working on a project where the same product will be placed multiable times, but need to be recorded seperately to show the the quantity used in each area.

Sheet 1 for example:
Product Quanity Total
35-5 5 5
35-5 2 2

I have set up a "Master" tabulation sheet that reference each sheet using VLOOKUP. What I cant figure out is how to get the sum of product 35-5 to show up as a quantity of 7 on the "Master" tabulation sheet. The "Master" sheet only shows the first quantity listed under each product, for example the "Master" sheet on tell me there are 5 units of the product 35-5.

How can I fix this so that the "Master" sheet shows the sum of the same products it is referencing from each sheet?