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