Subtotaling based on product descrption

[failer]

I have a workbook with a multpile sheets with lists of wine types and qtys shipped by date. I want to create a summary sheet that subtotals all of these qtys by article. There are over 300 types and are changing sheet by sheet so I can't just do a plain subtotal across the worksheets formula as the articles don't hold the same cell ref sheet by sheet. I need a formula that looks at the product name in cloumn E of the summary and searches across the other sheets if there is a repeat of the article then subtotal any qty from cloumn F of these sheets.

Hope it makes sense.

[arlu1201]

Why dont you attach a sample file with some dummy data?

[failer]

Hope this works as its my first time to try it.

Sample.xls

[arlu1201]

Are there chances that sheets will be added to the workbook over time, which will also need to be included in the subtotal?

[failer]

No..This is a snapshot of historical data, so what is on the sheet is the complete data sample.

[arlu1201]

There is a similar solution provided in this thread...you can adapt it to your file ... http://www.excelforum.com/excel-gene...orksheets.html

[failer]

Thanks. Will try and make it fit as a solution.

Thanks again.