Don't include the summary sheet among the start - finish sheets
best would be to drag it to the left (just drag it with the mouse) and have
the summary as the first sheet then do the calculation with the rest of the
sheets


--
Regards,

Peo Sjoblom



"lindyphil14" wrote in message
...
mmmm now it tells me excel cannot calculate a formula, i am creating a
circular reference!

--
thank u very much


"Gord Dibben" wrote:

Don't rename the sheets.

Insert a new blank sheet before the sheets to SUM

Name it Start

Insert a new blank sheet after the sheets to SUM

Formula would be =SUM(Start:End!Z100)

When adding new sheets in the future make sure they are inserted between
Start
and End.


Gord Dibben MS Excel MVP



On Sun, 17 Jun 2007 14:24:00 -0700, lindyphil14
wrote:

thank u very much i will rename the sheets and try again