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?

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

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"AC" wrote:

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?

Take a look SUMIF function in help menu


"AC" wrote:

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?