'[workbook1.xls]Sheet1'!$B$1+'[workbook2.xls]Sheet1'!$B$1+'[workbook3.xls]Sheet1'!$B$1+etc..........

You'd have to do this 43 times but it will work.

"Pinlaro" wrote:

Hi there

Please help. I have 43 different workbooks, each containing 9 named
worksheets ie toys, carrots, flowers and cats containing about 11 columns of
information.

Basically I want the totals of "column B" on worksheet called "toys" in the
43 workbooks added up.

I can put all 43 workbooks on one workbook if thats going to make it easier.
Unfortunately the totals arent all in the same cell.

Any suggestions?