Sum values in column D that correspond to values in column A VLOOKUP and IFSUM?

[lanejordan]

I'm using Excel 2007.

I have the following dataset:

STK-00	Fairbanks, AK	31535	2
STK-00	Palmer, AK	5937	1
STK-00	Wasilla, AK	7831	1
STA-01	Daphne, AL	21570	1
STA-01	Fairhope, AL	15326	1
STA-01	Foley, AL	14618	1
STA-01	Millry, AL	546	1
STA-01	Mobile, AL	195111	4

<tbody>
</tbody>

I want to look up each value in the first column (e.g., STK-00) and sum its corresponding values in the last column. For example, STK-00's sum is 4. For STA-01, the sum is 8.


How can I do this with excel functions?

 

[shg]

See Help for the SUMIF function.

 

[Aladin Akyurek]

SUMIF($A$2:$A$9,E2.$D$2:$D$9)

where E2 = STK-00.

 

[lanejordan]

Got it!