Forum Discussion
Accum Wins from Competitor-Day Table
Assuming a couple of things:
a) you have Excel 365 and you can use the new formulas like GROUPBY
b) the format of the data is how I set it up in the screenshot below
then the formulas are shown in I1 and I8 (for the cells directly below them respectfully). They are the same concept but 1 uses MMULT and the other uses BYROW, but in both cases that basically collapses the columns into a singlle column with either a value of 1 if there is an "o" on that row or a Zero (0) if not. Then in both cases the GROUPBY function does the work of collating the results per person/name. Here are the formulas for cut/paste:
=GROUPBY(A2:A21,MMULT(--(B2:F21="o"),--TRANSPOSE(B1:F1<>"")),SUM,0,0)
=GROUPBY(A2:A21,BYROW(--(B2:F21="o"),SUM),SUM,0,0)
- 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.
Thank you for your solution, but I'd prefer not to have to rearrange the data table. I've laid it out as Grand Sumo does and my goal is to reduce the number of steps, not increase.