Forum Discussion
Accum Wins from Competitor-Day Table
You can use SUMIF to calculate each wrestler's accumulated wins, even when the wrestler order changes each day.
Assuming:
- Column A contains wrestler names.
- Columns B:G contain daily results (`O` = win, `X` = loss).
- Column H contains the wrestler name for the selected day.
- Column I is Accum Wins.
Enter this formula in I2:
excel
excel
=COUNTIFS($A$2:$A$100,H2,$B$2:$G$100,"O")
However, if you need accumulated wins only up to the current day, use a formula that counts wins in the relevant day columns.
For example, for Day 2:
excel
excel
=COUNTIFS($A$2:$A$100,H2,$B$2:C$100,"O")
Adjust the ending column as the tournament progresses.
This matches wrestlers by name, so their changing order won't affect the results\!
- scrail2004Nov 18, 2026Brass Contributor
The moderator would not let me respond in a single response to everyone who offered a solution, so I am responding to each of you individually.
I couldn't get your solution to work. It worked for Day 1, but didn't work when I modified the formula for Day 1 through 2. I have attached the Excel file that did not get through the first time (now with a tab showing your solution). Hopefully, seeing it will help.