Sum the total for each unique name

[hyoung3]

Ugh, I have another question.

I have a list of names (some duplicates) in column A and a number for each name in column B. I need to take the sum of of each number for each unique name only and put it in another column. A visual example

This:
AAA 50
AAA 100
AAA 25
BBB 60
BBB 40

Needs to become:
AAA 175
BBB 100

Any thoughts?

Thanks

 

[MrKowz]

Try a Pivot Table. They are really handy for summarizing information.

 

[hyoung3]

I didn't even think about that. Thanks!

 

[Dartagnan]

Another thought. A sumif should work well.

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