sumproduct to sum values for 11 conditions--HELP ASAP!

[J-Rowz]

I need to sum the market values of a group of 11 stocks, identified by three letter tickers. I have three columns with data. Column A has 114 three-letter tickers, Column B has 114 market values associated with those tickers, Column C has the list of 11 tickers that I want a sum of market values. I am not able to get a sumproduct formula to work when I reference the list of tickers as an array.

Here is the formula I am trying to use: =SUMPRODUCT(--(A:A=C1:C11),B:B)

Can someone please help me?!

Thanks,
Jared

 

[Laurent C]

Wrong thread.

However, you might want to check whether comparing the whole column A with C1:C11 is the right thing to do.

Edit: also, you might want to use SUMIF to do the job.

 

[barry houdini]

Try this

=SUMPRODUCT(SUMIF(A:A,C1:C11,B:B))