Yes, Mr Dibben you are right. Thanks for the tip

Shail

On Dec 14 2006, 10:28 pm, Gord Dibben <gorddibbATshawDOTca wrote:
Shail

Your first post allows for new sheets to be inserted between sheet1 and sheet2
and is a good method.

Best though to name them Start and End so's not to confuse with default sheet
names.

Gord Dibben MS Excel MVP

On 14 Dec 2006 05:47:07 -0800, "shail" wrote:



Oh I guess, there is no need to add two sheets. It can work as this way
too -

=SUM(Jan:Dec!K5)

Thanks,

Shail

shail wrote:
Try this one too,

Make 2 sheets. Place the 1st one before January and place the 2nd one
after December tab. Now on the Year sheet write down the formula to sum
the K5 cells

I have named these 2 worksheets as "sheet1" & "sheet2"

=SUM(sheet1:sheet2!K5)

This way the sheets between sheet1 and sheet2 will be sumed. And you
can copy the formula down.

Hope that helps.

Shail

KMH wrote:
hello, i have a woorbook with tabs for every month and a year end tab. The
tabs have names from cells 5 - 56 on it with performances in A thru K. Is
there a formula i can use for the first individual to have all of their
monthly K5 cells add up on the year to date sheet, and then just drag that
down so it applies to the other 50 people and their specific totals on the
monthly tabs
--
Thanks for your help, advice, ideas, and time.- Hide quoted text -

- Show quoted text -