Forum Discussion
Accum Wins from Competitor-Day Table
You can solve this using SUMPRODUCT and INDEX/MATCH to find each wrestler's row and count all their wins up to the current day.
Assuming:
- Column A contains wrestler names.
- Columns B:G contain tournament results (O = win, X = loss).
- Column H contains the wrestler name for the daily summary.
- Column I is Accum Wins.
Enter this formula in I2 and copy it down:
excel
excel
=COUNTIF(INDEX($B$2:$G$100,MATCH(H2,$A$2:$A$100,0),0),"O")
How it works:
- `MATCH` finds the wrestler's row in the results table.
- `INDEX` retrieves that wrestler's results across all tournament days.
- `COUNTIF` counts the number of wins ("O").
Important: This formula counts wins across the entire tournament. If you want accumulated wins only through the current day, the formula needs to account for which day is being displayed.
For that, you can use:
excel
excel
=COUNTIF(INDEX($B$2:$G$100,MATCH(H2,$A$2:$A$100,0),1):INDEX($B$2:$G$100,MATCH(H2,$A$2:$A$100,0),MATCH(G$1,$B$1:$G$1,0)),"O")
Adjust the day header reference to match your workbook.
This will calculate each wrestler's cumulative wins up to the specified day, regardless of how the wrestler order changes in column H.
- 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.
Your solution worked. Now I’ll work on fitting it into my actual workbook.
I have attached the Excel file that did not make it through the first time (now with a tab showing your solution).
Thanks for the help!