Counting Values in Column A based on value in Column B

[RyanFoyBMO]

I want to Sum values from Column A based on a specific Value in Column B. In the sample below I would want the total for each name based on values in Column A. For Example, John would = 15 total, Ryan = 7, etc.

[TABLE="width: 500"]
<tbody>[TR]
[TD]#[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]John[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Ryan[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Mike[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]John[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Ryan[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Mike[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[mrshl9898]

=SUMIF(B:B,"John",A:A)

 

[RyanFoyBMO]

=SUMIF(B:B,"John",A:A)

Thanks! Worked Perfectly. Can this same function be used for blank cells in Column B?

Ryan

 

[mrshl9898]

Yeah, it would pick up all blanks after the data too though.

So you might want something like = SUMIF(B2:B100,"",A1:A100) or whichever row the data starts and stops at.

 

[RyanFoyBMO]

yeah, it would pick up all blanks after the data too though.

So you might want something like = sumif(b2:b100,"",a1:a100) or whichever row the data starts and stops at.

thanks!