Adding cells from multiple workbooks

B

Blackcat

I have approx 20 workbooks whcih are set up identically.

I need to add the data per cell ( eg A1+A1+A1 etc) in a summary workbook but
because of the number of workbooks it's unmanageable to simply add each cell.

Is there a simple way of doing this using "SUM" or whatever?

Thanks for any help
 
T

tjtjjtjt

You can check out the Data | Consolidate Feature. It's designed to do exactly
what you are asking.
Check out the Help Topic Consolidate data.

tj
 
B

Bob Phillips

Try

=SUM(Sheet2:Sheet9!A1)

just change the names to your first and last sheet

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
B

Bob Phillips

Then I think that you are stuck with individually adding them.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top