Sum values that match a specified value?

**cpeyton** · 10-09-2009, 04:59 PM

Is there a function that will look through a column of data (eg column A), find any cells that match another specified cell (eg C1) and sum the values of the corresponding cells in column B next to the matched cell?

I know that's confusing, let me use any example:

A__________B__________C
_____________________AAPL
AAPL_______25
CMI________30
INTU_______40
MON________5
AAPL_______100
EBAY________60

So, I want the function to look through the list in column A and return the sum of the values that match the specified value (AAPL in column C). So here, the answer would be 125 (25+100).

Thank you very much for your help and please respond with questions if you don't understand what I am asking!

Cole

**GuruWannaB** · 10-09-2009, 05:04 PM

Try this:

Code:

=SUMIF(A2:A7,"="&C1,B2:B7)

**JP Romano** · 10-09-2009, 05:07 PM

Hi...in excel 2007 that would be
=SUMIFS(B2:B7,A2:A7,C1)

I don't have access to earlier versions, so I'm not sure if that function even existed prior. I'll check and see if I can find out!