Sumproduct across several sheets

[stuhendry]

Hi All,

I'm looking for some help in obtaining a cumulative total of quantities across several sheets. I've attached a test workbook for reference.

I had used the vlookup + vlookup but seem to be returning errors on too many occasions

Sheet 1 contains the summary that details the 'Item' (items will vary across sheets depending on the customer) and quantity, I am needing this to check the other sheets and perform a sum of the matching item

Many thanks
Stuart

[Punnam]

Hi,

Find the attached sheet as per your requirement .

Punnam

[JohnTopley]

@Punnam,
Please add an explanation / formulae used to your post.

[stuhendry]

Legend!

Many thanks

[Punnam]

1) i have used Sumif + Sumproduct + Indirect + Name range

an extra sheet showing the sheet names "Sheetname"

Please Login or Register  to view this content.

Punnam