LOOK UP AND SUM

[AC]

I am trying to look through a list on names in one column and values in the
column next.
If I have a name that repeats I want to add all the corresponding values
from the column next.
EG.
ABC 11
ZXY 8
GUK 22
ABC 3
ABC 8

ABC Total = 22

Any ideas?

 

[ryguy7272]

=SUMPRODUCT(--(A1:A5="ABC"),--(B1:B5))
=SUMPRODUCT((A1:A5="ABC")*(B1:B5))

HTH,
Ryan---

 

[Teethless mama]

Take a look SUMIF function in help menu