hi i am new to excel heelllpppp
wheyyyy i have placed a start and end sheet!!! now to get the formula right
--
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
|