Re: Summing values of corresponding columns

From: Aladin Akyurek (Aladin.Akyurek.1f7vyt_at_excelforum-nospam.com)
Date: 11/04/04 

Date: Thu, 4 Nov 2004 16:06:55 -0600

=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?action=getinfo&userid=4165
View this thread: http://www.excelforum.com/showthread.php?threadid=275452