Baseball Stat sheet

[Deborah]

For a baseball stat sheet, I have a Total page that
sums cells (eg At Bats) from each individual Game1, Game2
etc. worksheet. I don't want to have to modify the Total
worksheet formulas every time I add another Game
worksheet. Is there some way to sum worksheets using a
common prefix (=sum(Game&!D17)) or some other function I
can use? Thanks.

 

[Frank Kabel]

Hi
one way:
- create a first and last sheet (you could leave them empty). Now only
insert your new sheets between these two sheets and use the following
formula
=SUM('start:end'!D17)
for an overall total

If you need this for each individual sheet try the following formula:
=INDIRECT("'Game" & ROW(1:1) & "'!D17")
and copy this down

 

[Deborah]

Thank you so much. That worked great!
Deborah

-----Original Message-----
Hi
one way:
- create a first and last sheet (you could leave them empty). Now only
insert your new sheets between these two sheets and use the following
formula
=SUM('start:end'!D17)
for an overall total

If you need this for each individual sheet try the following formula:
=INDIRECT("'Game" & ROW(1:1) & "'!D17")
and copy this down

--
Regards
Frank Kabel
Frankfurt, Germany



.