Summarising Numerous Worksheets
 

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

Summarising Numerous Worksheets
 

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


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

Summarising Numerous Worksheets
 

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/comm...3-41a5b4b68ce8
--
-Kaman
The IT dept people call before they call the real IT dept.


"pepperds" wrote:

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