I have made my own statistic worksheet for my husband's baseball team. I
would like to enter stats from each game & then get season totals on one
sheet without having to physically add each stat up for each player. I have
tried to do the consolidation thing but am at a loss. I have formulas to
figure specific stats. I have multiple rows, with multiple columns on
multiple sheets. Any help would be useful.
Ex: Player A stats include Hits, At bats, Runs, Fielding Errors, Left on
Base, Hit by pitch, Sacrafice, ect. Some of these stats are then used in
formulas to generate On Base percentage, Batting Avg, ERA, and so on.

Thank you,
--
Renae
Mom & youth sports nut

EXCEL 2007

Assuming that your totals are all in the same cell (for example C6) on the
different Worksheets the following should work.

=SUM(North:Mid!C6)

1. Place the above in the cell where you want the overall total to be.

2. Replace North with the name of your first (furthest to the left)
Worksheet.

3. Replace Mid with the name of your last (furthest to the right) Worksheet.

You should then get a total of all the Worksheets' cell C6 in the cell where
you have placed the above formula.

If my comments have helped please hit Yes.

Thanks.



"Rennietmac" wrote:

I have made my own statistic worksheet for my husband's baseball team. I
would like to enter stats from each game & then get season totals on one
sheet without having to physically add each stat up for each player. I have
tried to do the consolidation thing but am at a loss. I have formulas to
figure specific stats. I have multiple rows, with multiple columns on
multiple sheets. Any help would be useful.
Ex: Player A stats include Hits, At bats, Runs, Fielding Errors, Left on
Base, Hit by pitch, Sacrafice, ect. Some of these stats are then used in
formulas to generate On Base percentage, Batting Avg, ERA, and so on.

Thank you,
--
Renae
Mom & youth sports nut