count repeating cell's value (to the right)

[davidstoll]

I appologize, but I don't know the correct lingo for what I'm trying to do. I searched the forumns and I'm sure it's in there, but I probably don't know the correct key words.

Column A has a list of names (some repeats).
Column B has numeric values.

I want to count all the Column B values that correspond to the same name in A.

A | B
------
a | 1
b | 2
c | 4
a | 2
a | 1
b | 1

I want to total all the a, b and c entry's corresponding B values.
a = 4
b = 3
c = 4

I think I need vlookup, but vlookup only finds the first 'a' and reports the value for that one only. i.e. =vlookup("a",A1:B6,2,false), which would give me 1..which only references the first "a".

Thanks guys

 

[Andrew Poulsom]

It's:

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

You can use a cell reference in place of "a".

 

[davidstoll]

It's:

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

You can use a cell reference in place of "a".

Oh my word. That's so simple.

Thank you, I appreciate it!

David