I have a workbook where worksheet 1 is a cummulative statistic sheet for a basketball team I coach. Worksheets 2-25 are individual game statistics. Everytime I enter game statistics in worksheets 2-25 the cummulative total sheet is automatically updated. My question is, "Can I have two cummulative totals worksheets that updates depending on whether our team wins or loses. In other words if we win, can these statistics automatically accumulate on worksheet 1 and if we lose, can these statistics accumulate on worksheet 2?"
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Season basketball statistic sheet
- Thread starter presleym
- Start date
just_jon
Legend
- Joined
- Sep 3, 2002
- Messages
- 10,473
A cheap solution:
1] Put your Win summary/Loss summary sheets as, say, the 1st 2 sheets in the workbook.
2] Enter a dummy sheet called (for instance) WinStart, another called WinEnd, a third called LossStart, and a fourth called LossEnd as the next set of sheets.
3] After entering your data in games 1-25, move the sheet for that game to either in-between WinStart-WinEnd, or LossStart-LossEnd.
4] Reference, using 3-D formulas, the sum of sheets from WinStart thru WinEnd for your Win Summary sheet
5] Reference, again using 3-D Summaries, the sum of sheets from LossStart thru LossEnd for your loss summary.
1] Put your Win summary/Loss summary sheets as, say, the 1st 2 sheets in the workbook.
2] Enter a dummy sheet called (for instance) WinStart, another called WinEnd, a third called LossStart, and a fourth called LossEnd as the next set of sheets.
3] After entering your data in games 1-25, move the sheet for that game to either in-between WinStart-WinEnd, or LossStart-LossEnd.
4] Reference, using 3-D formulas, the sum of sheets from WinStart thru WinEnd for your Win Summary sheet
5] Reference, again using 3-D Summaries, the sum of sheets from LossStart thru LossEnd for your loss summary.
Upvote
0
