Addtion with Vlookup

[dinesharma_1]

I want to add values(Qty) of all items from multiple (more than 25) sheets, all sheets has list of many items.The addition should appears in a separate sheet.I'm using vlookup & add functions but it is not working .

 

[Robert Mika]

Hi and welcome to the board.
Look here:
http://help.wugnet.com/office/SUMIF-multiple-worksheets-ftopict1157402.html

Good explanation how to use SUMIF and INDIRECT

 

[dinesharma_1]

Not working, since we has to find the qty's from 35 worksheets using vlookup then add.