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

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

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

Thank you!
Do

--
Don12
-----------------------------------------------------------------------
Don123's Profile: http://www.excelforum.com/member.php...fo&userid=3438
View this thread: http://www.excelforum.com/showthread.php?threadid=54169