LOOK UP AND SUM

  • Thread starter Thread starter AC
  • Start date Start date
A

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?
 
=SUMPRODUCT(--(A1:A5="ABC"),--(B1:B5))
=SUMPRODUCT((A1:A5="ABC")*(B1:B5))

HTH,
Ryan---
 
Back
Top