Hello,
I am wondering if there is an easy way to do this. If excel supports with a
method.

If I have a range. Maybe A1 to B20
Lets say column A has a word in it. And column B has numbers.
So maybe like this

aaa,4
aaa,7
bbb,9
bbb,3
bbb,4
ccc,4
ddd,5


Is there a way to add up all the bbb numbers? Using this range?

thanks