I am sure there is a compact formula, just can't put it together.
I have two columns.
Col A has names, Col B has qty.
I need a formula that can look for Three names [call them A,B,C] and add all items from Col B matching these names.



Here's a typical setup.

A 10
B 15
C 20
B 10
C 15
A 20
D 25
E 10
F 15
C 20
A 15
B 20
D 15
F 25
C 10

Thanks for your help.