Adding cells from multiple workbooks

[Guest]

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

 

[Guest]

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

 

[Norman Jones]

Hi Blackcat,

You can sum between dummy sheets as described in a post fro Tom Ogilvy:

'---------------------------------->>
'From: Tom Ogilvy
Put in two extra blank sheets. Name one Start, name one Finish


Now in the summary sheet put in a formula


=Sum(Start:Finish!A4)

insert your daily sheets between start (at the front) and finish at the end.
Put your summary shout outside of these two boundary sheet.


--
Regards,
Tom Ogilvy


'----------------------------------<<

 

[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)

 

[Ron de Bruin]

Hi Bob

Check your Inbox please

 

[Guest]

The sheets are in different workbooks though and because of the distribution
need to stay there.

 

[Bob Phillips]

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

--

HTH

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