Need Help -- Baseball stats in excel only has 23 pages--Need to addmore pages..

[GE Cathey]

Need Help -- Baseball stats in excel only has 23 pages--Need to add more
pages...and have the "summary function" work on all pages.

Someone I don't know, set this spreadsheet up and it keeps game by game
info such as batting averages and slugging averages and it keeps same
info as a "season summary". I added the extra pages I needed but
unfortunately, the season summary doesn't take account of any info past
page 23.

Any ideas?

George Cathey


Don't go to this link unless you want to see some sports illustrations
(other stuff too)

http://www.workbook.com/portfolios/cathey/

 

[Dave Peterson]

Check your other post.

Need Help -- Baseball stats in excel only has 23 pages--Need to add more
pages...and have the "summary function" work on all pages.

Someone I don't know, set this spreadsheet up and it keeps game by game
info such as batting averages and slugging averages and it keeps same
info as a "season summary". I added the extra pages I needed but
unfortunately, the season summary doesn't take account of any info past
page 23.

Any ideas?

George Cathey

Don't go to this link unless you want to see some sports illustrations
(other stuff too)

http://www.workbook.com/portfolios/cathey/

 

[Dave Peterson]

If you look at a formula on the summary worksheet, you'll see that they look
like:

=SUM('Game 1:Game 23'!D3)

If you insert the new worksheet to the right of "game 23" (or to the left of
"Game 1"), you'll have to change the formula.

But you could just insert the new game in between those two worksheets. It
might look a little weird if you see

Game 1, Game 2, ..., Game 24, Game 25, then Game 23

but the summary worksheet will work fine.

 

[Dave Peterson]

Ps. You may want to ask the developer (for next year???) to add a couple more
worksheets. One would be called Start and the other End--and all the game
worksheets would have been between those two.

And the formula would be changed to:

=SUM('Start:End'!D3)