[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!