Updating a formula to include values from a newly added tab

[travis.m.roberts]

Is there a way to automatically have a formula updated to include any tabs that are added? I have a spreadsheet that starts out with two tabs (summary page and one heavily formatted sheet). The summary page has a bunch of formulas on it that I would like to have updated to include values from a new tab each time it is inserted. For instance if the formula is =SUM('090800'!Q35) and I add a tab named 090900 I need the formula on the summary page to be updated as such: =SUM('090800'!Q35,'090900'!Q35). Is that possible?

 

[taigovinda]

You can add two blank tabs called FIRST and LAST. Then put all the sheets to be summed in between the two tabs, and use this formula:

=SUM('First:Last'!Q35)

...the FIRST and LAST tabs can be hidden also.

 

[Boller]

..

 

[jim may]

Insert a New Sheet immediately after your Summary Sheet and name it First
Insert another new sheet and drag it into the last position to the right and name it Last

The summary sheet could have this formula in it:

=SUM(First:Last!Q35)

All the data sheet should be BETWEEN the First and the Last << Careful on this; If you
do -- this will do what you want..

Good Luck,

Jim

 

[travis.m.roberts]

ok thats the trick. thanks folks.