Forum Discussion
Accum Wins from Competitor-Day Table
There's a snag in the two formula suggestions above, and it's worth fixing before you copy them down — the COUNTIFS ones won't run as written. In Excel every range in COUNTIFS has to be the same size, rows and columns, or you get a #VALUE! error. The name range there is one column wide and the results range is six columns wide, so that version can't work.
The INDEX idea in the first reply is the right direction, it just needs the end of the range tied to the day you're counting up to. If your results run in B:G with the day labels in row 1, names in A and the wrestler for the summary row in H2, try this in I2 and copy it down:
=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(J2,$B$1:$G$1,0)),"O")
Here J2 would be the day label for that summary row — Day 1, Day 2, and so on. MATCH finds the wrestler's row, the first INDEX starts the count at Day 1, and the second INDEX stops it at the day in J2, so the total grows day by day instead of counting the whole tournament at once. The changing order in column H doesn't matter, because everything is matched by name.
If your day labels sit somewhere other than row 1, just point the last MATCH at that row instead. And if you can re-attach the workbook Riny asked for, it's easy to check the exact columns against it.