Sports Standings Excel Question

[draper0521]

Thank you for your time. I keep baseball standings for a group. After each season, wins, losses, runs scored, runs allowed and winning percentage are all added into a spreadsheet, in order based on the standings from that season.

We have multiple seasons. I'm wondering if there is a formula to search for team name and add each team's wins, loss, etc to a to show the overall standings from the entire worksheet without doing it manually. I hope that makes sense. Thanks

 

[petertenthije]

If you put all seasons below each other like you did with 2023 and 2024, then this can be done with a SUMIFS formula.

For instance, in cell W7 you would want the sum of all fields in column C where the name in column B is the same as the name in L7.

The formule for W7 then becomes:

=sumifs(C:C,$B:$B,$L7)

This formula can then be copied into every "overall standing" field.
You are missing column "GB" in your overal standings. Therefor you will have to slightly modify the formula for columns P and Q.

The team names do have to be unique though! Otherwise another identifier would have to be added, probably based on division.

 

[draper0521]

If you put all seasons below each other like you did with 2023 and 2024, then this can be done with a SUMIFS formula.

For instance, in cell W7 you would want the sum of all fields in column C where the name in column B is the same as the name in L7.

The formule for W7 then becomes:

=sumifs(C:C,$B:$B,$L7)

This formula can then be copied into every "overall standing" field.
You are missing column "GB" in your overal standings. Therefor you will have to slightly modify the formula for columns P and Q.

The team names do have to be unique though! Otherwise another identifier would have to be added, probably based on division.

Thank you very much!