accumulated totals var with same name

Hi,
I would like a formula to determine accumulated totals for same names where value =1
Please see attachment
Many thanks
Ian
raceproretiredAsked:
Who is Participating?
 
Ryan ChongConnect With a Mentor Commented:
sample as attached.
Accum-Wins-same-name_b.xlsx
0
 
Ryan ChongCommented:
in general, you would need to use SumIf or SumIfs function.

MS Excel: How to use the SUMIF Function (WS)
https://www.techonthenet.com/excel/formulas/sumif.php

MS Excel: How to use the SUMIFS Function (WS)
https://www.techonthenet.com/excel/formulas/sumifs.php

pls attach your document for our references.
0
 
raceproretiredAuthor Commented:
oops I forgot to click on the Upload File button
sorry :)
see attached
Accum-Wins-same-name.xlsx
0
 
Ryan ChongCommented:
you may try use formula like this in C2:

=COUNTIFS($A$1:A2,A2,$B$1:B2,1)

Open in new window

and drag down your formula for the rest of the cells.
0
 
raceproretiredAuthor Commented:
That was simple.
Works well
Thanks Ryan
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.