How can I retrieve the sum of only the values in column B, in which the
corresponding value in column A is equal some "search value" I
specify?
Example table
_A_|_B_
1 | 20
2 | 24
3 | 21
2 | 45
1 | 67
3 | 32
2 | 10
1 | 26
Desired answer if "search value" is 1: the sum of 20, 67, 26 ... which
is 113
I've been able to retrieve the first value, using VLOOKUP. But, I need
to somehow imbed the VLOOKUP function inside another function that
returns all the values - at least thats how I envision it.
Any help would be greatly appreciated. Thank you,
Lance G
--
lanceg
------------------------------------------------------------------------
lanceg's Profile:
http://www.excelforum.com/member.php...o&userid=16097
View this thread:
http://www.excelforum.com/showthread...hreadid=275452