Sum values that match a specified value?

[cpeyton]

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]

Try this:

Please Login or Register  to view this content.

[JP Romano]

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!

[JP Romano]

GuruWannaB beat me to it, again, and with a more appropriate solution - good luck!

[cpeyton]

Thank you both! Worked perfectly. Thanks!

Cole