=SUMIF($A$2:$A$9,E2,$B$2:$B$9)
where E2 houses a condition like 1.
lanceg Wrote:
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
--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile:
http://www.excelforum.com/member.php...fo&userid=4165
View this thread:
http://www.excelforum.com/showthread...hreadid=275452