Tabulating Player Positions

[Don123]

I have a girl's softball team that I use Excel to make lineups for each game. I have created a new sheet for each game. So at the bottom where it usually says sheet 1, sheet 2, sheet 3, I have changed the wording to the actual date. There are a total of 16 games, or 16 sheets. It's important that each of my 12 players are able to play every position, hopefully the same amount of time as all the other players.

The spreadsheet is set up with the girl's names running down the A column and the positions spread across B thru K. I then rotate the girls every inning.

Question: What is the formula needed to add all my sheets together to come up with the number of times each girl plays a position, such as 1st base?
Emily: 1st base - 12 times
2nd base - 11 times

Thank you!
Don

[bgeier]

The easiest way I can think of is to have a summary sheet after the last game with the same information on it as the actual game sheets.
In the cells where you would put the actual time played, put

=SUM('2006-05-13'!B2,'2006-05-20'!B2,'2006-05-27!b2)

Once you have entered the formula in cell B2, you can copy cell B2 then paste it to each of the rest of the cells in the grid.