Totals of different worksheets.

P

Pinlaro

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?
 
R

RA

'[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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top