Sumif + vlookup

[ivwshane]

I've searched but the solutions don't seem to be what I need.

I have a workbook with multiple sheets. Sheet1 has a list of names (name1:name5)
The other sheets have data for name1:name5. Some of the names appear multiple times with their own data on sheet2:

name1 dataA dataB
name1 dataA dataB
name2 dataA dataB
name3 dataA dataB

On sheet1 I want to reference cell A1 to look up any matching names and add dataB.

So basically, add up all dataB instances where A1:A10 = name1

I'm thinking I need to use vlookup and then sumif but I'm not sure how to write it.

Thanks

[NBVC]

List all the sheetnames to search within in a single column of your summary sheet. Then name that range, through Insert|Name|Define and call it: TabNames

Then use formula:

Please Login or Register  to view this content.

adjust ranges to suit.

Note: If your sheets are truly named in some sort of sequential manner, like Sheet2, Sheet3, Sheet4, etc... then you don't need to list the sheetnames, you can use something more like:

Please Login or Register  to view this content.

Adjust ranges to suit..where 2:10 means Sheet2:Sheet10.