Returning multiple instances of the same lookup value

T

tw22

Joined
Jan 28, 2010
Messages
1
Reaction score
0
HI All

Is it possible to do the following?
How do you return the sum of multiple instances of a match using the lookup formula

Column A Column B

Pete 8
Al 2
Joe 3
Pete 8
Tony 4
Pete 1

I want to be able to look up Column A "Pete" and be able to add all relevant values 8,8,1 corresponding to Pete to return 17 in a another cell.
.
A$10 = Lookup Value
B$10 = Return value 17.

Thanks for anyone's assistance in this?
 

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

Lookup one value, Return matching correspnding values 7
match formula 2
Lookup against concatenated source value 2
Scrabble Value calculation for Welsh words 0
Lookup / Match ? 8
With F1 value, look at A, if match or partial match return B 5
Lookup in multiple columns 7
lookup multiple search criteria but only return a value if both tr 8

Top