Hey there party people,

This seems to be a question asked about before, however, no clear-cut answer solves my puzzle. I've tried variations of sumif and countif functions. Please let me know what you got.

My document is like this:

A B

123ABC 1000
123ABC 1500
456DEF 450
789GHI 500


I just want to get a new sheet that says:


A B

123ABC 2500
456DEF 450
789GHI 500


Please and thank you.