Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Baseball Stat Keeping
I'm coaching a team of youngsters, and would like to track individual stats
by game (1 worksheet per game) and totals for the season. The only problem I have is that the batting order is going to change every game (league rule). Player1 would be in row 1 one day and row 8 the next. So I thought that I could use the name function for each player and each stat. Something along the lines of, SUM(Player1 Hits) in the Season Total sheet. But you can't use the same name across sheets, and obviously the above formula wil not work. Any chance I can make this work? Thanks!!!! |
#2
|
|||
|
|||
On your "Season Total Sheet", use the lookup function (see help) and add the
lookup totals for each page. i.e. =Lookup(bob,sheet1,hitscolumn)+Lookup(bob,sheet2,h istscolumn)+... "John" wrote: I'm coaching a team of youngsters, and would like to track individual stats by game (1 worksheet per game) and totals for the season. The only problem I have is that the batting order is going to change every game (league rule). Player1 would be in row 1 one day and row 8 the next. So I thought that I could use the name function for each player and each stat. Something along the lines of, SUM(Player1 Hits) in the Season Total sheet. But you can't use the same name across sheets, and obviously the above formula wil not work. Any chance I can make this work? Thanks!!!! |
#3
|
|||
|
|||
Have you thought of using one worksheet for all your offensive data and one for
all the pitching data (and one for defense)? You could add a column that shows the game number and you could use: =sumif(), =countif(), =sumproduct(), pivottables to summarize your data. You'll be able to sort by name or by game or by any other field. Then you could use Data|Subtotals to get other stats. Debra Dalgleish has lots of notes for counting/summing at: http://www.contextures.com/xlFunctions04.html John wrote: I'm coaching a team of youngsters, and would like to track individual stats by game (1 worksheet per game) and totals for the season. The only problem I have is that the batting order is going to change every game (league rule). Player1 would be in row 1 one day and row 8 the next. So I thought that I could use the name function for each player and each stat. Something along the lines of, SUM(Player1 Hits) in the Season Total sheet. But you can't use the same name across sheets, and obviously the above formula wil not work. Any chance I can make this work? Thanks!!!! -- Dave Peterson |
#4
|
|||
|
|||
Well that kind of worked, thanks! The formula had to be =Lookup(Bill1,
AtBats1)+ Lookup(Bill2, AtBats2), since you can't have the same name for different cells in the same workbook (unless I am missing something). I was hoping that there would be an easier way. I tried this but it obviously would not work, though I think you get the idea of what would be perfect in the totals sheet... =SUM(Lookup(Bill*,AtBats*)) "stacyjhaskins" wrote: On your "Season Total Sheet", use the lookup function (see help) and add the lookup totals for each page. i.e. =Lookup(bob,sheet1,hitscolumn)+Lookup(bob,sheet2,h istscolumn)+... "John" wrote: I'm coaching a team of youngsters, and would like to track individual stats by game (1 worksheet per game) and totals for the season. The only problem I have is that the batting order is going to change every game (league rule). Player1 would be in row 1 one day and row 8 the next. So I thought that I could use the name function for each player and each stat. Something along the lines of, SUM(Player1 Hits) in the Season Total sheet. But you can't use the same name across sheets, and obviously the above formula wil not work. Any chance I can make this work? Thanks!!!! |
#5
|
|||
|
|||
I'd rather break it down game by game (one game per sheet), with a total
sheet being updated when games are added. "Dave Peterson" wrote: Have you thought of using one worksheet for all your offensive data and one for all the pitching data (and one for defense)? You could add a column that shows the game number and you could use: =sumif(), =countif(), =sumproduct(), pivottables to summarize your data. You'll be able to sort by name or by game or by any other field. Then you could use Data|Subtotals to get other stats. Debra Dalgleish has lots of notes for counting/summing at: http://www.contextures.com/xlFunctions04.html John wrote: I'm coaching a team of youngsters, and would like to track individual stats by game (1 worksheet per game) and totals for the season. The only problem I have is that the batting order is going to change every game (league rule). Player1 would be in row 1 one day and row 8 the next. So I thought that I could use the name function for each player and each stat. Something along the lines of, SUM(Player1 Hits) in the Season Total sheet. But you can't use the same name across sheets, and obviously the above formula wil not work. Any chance I can make this work? Thanks!!!! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy cells with keeping exact formula intact | Excel Discussion (Misc queries) | |||
Fantacy Baseball Draft 2005 | Excel Discussion (Misc queries) | |||
Help with keeping track of payments | Excel Discussion (Misc queries) | |||
How do I fill down keeping one cell calculation from changing in . | Excel Discussion (Misc queries) | |||
Does anyone have a spreadsheet tracking season long baseball stat. | Excel Worksheet Functions |