Quick Excel for the Geeks

[jyl]

D381000 is List A of stock tickers.
E38:E1000 is a list of portfolio weights corresponding to each ticker in List A.
F7:F20 is List B of stock tickers, some will be in List A, some will not.

I want a formula that gives me the sum of weights for the tickers in List A that are also tickers in List B.

I know how to do this in two steps (pulling weights from E38:E1000 for each List B ticker into G7:G20, then summing G7:G20), but I want to do it all in one cell, one formula.

Thanks!

[Amail]

=sum(sumif(d38:d1000,f7:f20,e38:e1000))

[masraum]

Originally Posted by Amail

=sum(sumif(d38:d1000,f7:f20,e38:e1000))

I'm not an Excel expert by any stretch of the imagination, but I know how to do several things and have done lots of various sorts of formulas over the years. It was just last week that I used "sumif" and then "sumifs" for the first time.

[jyl]

Thank you!

[herr_oberst]

PPOT perfectly summed up in one thread.

[jyl]

I am bad at array formulae :-(