Statistics Sheet - getting cumulative from many sheets

[Snydek]

I have a spreadsheet that I created to track my sons basketball teams' stats.. for the past 2 years I have manually kept the "Cumulative" sheet up to date but I was wondering had another suggestion.. I use a new sheet for each game.. is there a way to have the Cumulative (Sheet 1) update automatically when I add a new sheet for a new game and enter the stats? I know I could use =sheet2!A1+sheet3!A1...etc.. but is there a better way? I have attached the spreadsheet I used for last season..

Thanks in advance!!

Kyle Snyder

[newdoverman]

I inserted two blank worksheets named Start and End. You insert new worksheets between these two. If you keep the new worksheets exactly laid out as the other worksheets, the totals will be correct. As far as I can see, all regular season games have the exact same layout. This calculation is relying on that. It it is different than that, the formula will be different.
Enter in C2 of Season Totals this formula and fill down to C9 and across to N9.

=SUM(Start:End!B2)+PreSeasonTourney!B16+PreSeasonTourney!B30+PreSeasonTourney!B44

If you don't want to include PreSeason move the Start worksheet to the right of the PreseasonTourney and use this formula:

=SUM(Start:End!B2)

I can't determine how you can tell if a player has played or not because all the names appear on all the worksheets and there is no indication that I can see if they played or not. The only thing that I can see is that all the players have played 23 games not including Preseason.

[FDibbins]

Hi, welcome to the forum

This will work for the regular games, you will need something else for the "tourney" sheets.
if you add a blank worksheet at the start and end of your data sheets, and call them Start and End, then when you enter your calcs, you could just enter =sum('start:End'!C12) or whatever your references are. this way, you can add or remove sheets as needed, and it will add across all the sheets you need it to, and keep the totals as the data sheets change. make sure your "Master" sheet is before the Start sheet though

You can move move sheets by click/hold and dragging them

[Snydek]

Awesome!! Thanks to you both.. this is exactly what I was looking for.. can I have more than 1 "Start:End" pair? Like could I also have "TouneyStart:TourneyEnd" and put all tournament games between them and it would act the same?

Thanks Again!!

[FDibbins]

Yes, you can - give it a try and see how it works for you. the actual names of the start and end sheets does not really matter at all, it is simply a way to tell excel that you want to SUM all A1 cells in the sheets from X to Y - the words themselves just need to match what your sheets are called

I have a feeling though, that your requirements for the tourney's may be a bit different?

[newdoverman]

As Ford says, "give it a try". You have an example of how the formulae work. You can separate tournaments from regular season in the manner you describe. Make sure that the sheets don't overlap starts and ends or you will be adding some stats a couple of times where you don't want.

If you have further problems just post what you need.

Good luck.