Tabulating Player Positions  
Author Message
kalyani





PostPosted: Sat May 13 03:30:21 CDT 2006 Top

Excel Programming >> Tabulating Player Positions

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.hide-link.com/ ;userid=3438
View this thread: http://www.hide-link.com/

Excel286  
 
 
bgeier





PostPosted: Sat May 13 03:30:21 CDT 2006 Top

Excel Programming >> Tabulating Player Positions
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.


--
bgeier
------------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=12822
View this thread: http://www.excelforum.com/showthread.php?threadid=541697