Need help calculating won, loss records

[bgry66]

I have an NFL picks spreadsheet up and running for 13 people, everything works but was wondering if there is a way to calculate wins, losses, ties over multiple sheets ( 1 sheet per week, 17 week season ). Games played in week 1 would need to transfer wins, losses, ties to the following week (sheet 2 ) and so on. Not sure if it's possible the way mine is set up. Try my best to explain the setup..

A3 team1 B3 (wins column) C3 (loss column) D3 (ties column) E3 team1's score .............. F3,4 ( rows 3 & 4 are merged ) = winning team

A4 team2 B4 " " C4 " " D4 " " E4 team2's score

This is the only calculation I have left that isn't setup with a formula yet. All I do is enter teams scores and it figures each persons weekly and yearly wins, losses, weekly & yearly win %, a running total of wins, losses as a group & even each persons ranking.
Appreciate any help, These columns are consistent thru all 17 weeks. And example above runs from row 3 down thru row 34 for all 32 teams.

 

[steve the fish]

How is your summary sheet set up? If you have columns named the same as your sheet names (Week 1 etc) then its fairly simple to reference each sheet with one INDIRECT formula.

 

[bgry66]

[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]ROWS
[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD]1,2[/TD]
[TD]TEAMS[/TD]
[TD]W[/TD]
[TD]L[/TD]
[TD]T[/TD]
[TD]SCORE[/TD]
[TD]WINNER[/TD]
[TD]PICK[/TD]
[TD]W/L[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]GB[/TD]
[TD]8[/TD]
[TD]7[/TD]
[TD]1[/TD]
[TD]16[/TD]
[TD]SEA[/TD]
[TD]SEA
[/TD]
[TD]W
[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]SEA[/TD]
[TD]13[/TD]
[TD]3[/TD]
[TD][/TD]
[TD]36[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

How is your summary sheet set up? If you have columns named the same as your sheet names (Week 1 etc) then its fairly simple to reference each sheet with one INDIRECT formula.

This is how the columns & rows are setup except columns F, G, H rows 3 & 4 are merged to make them each 1 larger cell (same with row 1 & 2 ) Week 1 also has last years records for each team, and should begin this years record in week 2.
Thanks, hope this helps.

 

[steve the fish]

So you want a running total on next weeks sheet? That would be possible if sheet names compared with week numbers and the week number was present in each sheet. I think you would be better to have a summary table of results (ie Team WeekNumber Result (W,L,T)) to collate this then lookup off that each week.

 

[bgry66]

Thanks for the reply, I'm not an Excel expert but thought I'd check into this. Maybe it would be easier for me to just manually enter W,L,T each week. As of now all I do is enter the scores and it calculates everything else for me already, except the W,L,T cells & week 1 worked perfectly.