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.

#
12	John
5	Ryan
7	Mike
3	John
2	Ryan
5	Mike

<tbody>
</tbody>

 

[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!