LOOK UP AND SUM

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?
 
R

ryguy7272

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

HTH,
Ryan---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula (or code) return the largest number of duplicates in a list. 16
Combine information from two pages, two changing locations. 6
Help With Sumif 2
Match a value to multple criteria both in rows and columns 3
help with sum / count formula 9
Multiples conditions in an array 3
Help with Lookup function? 1
Is there any way of combining vlookup with getpivotdata? 1

Top