Summarising Numerous Worksheets

[Guest]

Hi,

I note a question & answer (below) which I see works well with worksheets
labelled Sheet1, Sheet2 etc;
---------------------------------------------------------------------------------------------
I am trying to add totals from 5 separte worksheets on the last worksheet
which I am calling a summary page. Can anyone share with me how to do this? I
tried the Sum button and then holding control as I click on each total on the
different worksheets but it doesn't seem to be working.

Assuming the amounts are on the same cell on each worksheet use a formula
like this:

=SUM(Sheet1:Sheet5!A1)
---------------------------------------------------------------------------------------------

However I'm curious whether the same could apply to an existing workbook
that I have which has 10 worksheets labelled in no particular order with
labels such as 'DK-NO-SE' & 'UK-IE'. Does the above formula apply in using
the first and last worksheet in the range?

cheers
Dave

 

[Ron de Bruin]

Yes, for more information see
http://www.rondebruin.nl/linksum.htm

 

[Guest]

Check out my answer I just posted about 10 mins ago. The same thing applies
here. If more than one cell, you can highlight as well...or hold down crtl
and click non-continous cells.

http://www.microsoft.com/office/com...ions&mid=faba9a37-5cd5-42e7-a973-41a5b4b68ce8