Quick Excel for the Geeks
 

D38:D1000 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!

=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.

Thank you!

PPOT perfectly summed up in one thread.

I am bad at array formulae :-(