Adding cells from multiple workbooks
 

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

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

"Blackcat" wrote:

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

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


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


---
Regards,
Norman



"Blackcat" wrote in message
...
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

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)


"Blackcat" wrote in message
...
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

Hi Bob

Check your Inbox please

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Bob Phillips" wrote in message ...
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)


"Blackcat" wrote in message
...
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

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




"Bob Phillips" wrote:

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)


"Blackcat" wrote in message
...
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

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

--

HTH

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


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




"Bob Phillips" wrote:

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)


"Blackcat" wrote in message
...
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