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