Hi Gord and Roger

Or this tip from this page
http://www.rondebruin.nl/linksum.htm


Tip: from Lori in the Public.Excel newsgroup on Nov-3-2006

=SUM('*'!A20)

Where the '*' automatically converts to all sheets other than the activate one.
WARNING: Not working in Excel 2002, it crashes the application.

If your workbook have 6 sheets and you enter this formula in sheet3 the formula looks like this.
=SUM(Sheet1:Sheet2!A20,Sheet4:Sheet6!A20)




--

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




"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
Slap forehead and thanks.


Gord

On Thu, 28 May 2009 09:33:05 +0100, "Roger Govier"
<roger@technology4unospamdotcodotuk wrote:

Hi Gord

Typo alert
Where A1 is total cell on each sheet.
to match with your formula, it should be where A10 is the total cell on
each sheet.

Hope all is well with you.