Scenario:
Data: A B
1 x 100
2 y 150
3 z 200
4 a 50
5
6 ("x","a")

I would like a formula that does something like:

sum the values in column B if the values in column A equals ANY of the
values in A6 i.e. A6 is a list or array of criteria. Partial criteria match
would be great too e.g. A3 is replaced with "apple" and A6 contains
(....,"ppl",...)