Counting Formula

[mikeywhits]

Hi all,

Hoping for some help. How do I count the accumulative number in row B if it matches criteria in row A. For example Adam would = 5.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Adam
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]John
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]Adam
[/TD]
[TD]3
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Cross Terrier]

In column C you need a SUMIF that you can drag down.

So, in this case in cell C3 you'd have

=SUMIF($A$1:A3,A3,$C$1:C3)

The top of each range is fixed, and then the values in column C will show the cumulative total for the name in column A to that point.