thank u gord
i know it sounds silly but..... i have inserted a sheet at the begining and
named it start but it is not allowing me to insert another at the end, i have
monday thro to sunday but when i try to insert after sunday it go in between
saturday & sunday!!
--
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