Sumifs with array criteria?

Question

I have a sheet with two columns: Key and Value.

I'd like to sum all of the Values that has a Key that matches some predefined list of items (e.g,. "Person A, Person B, Person C").

This predefined list of values also in my sheet, in the cells C1:C20.

Ideally, I'd like to do something like: sumifs($ValueColumn, $KeyColumn, C1:C20). I would like this to sum ONLY the Values that has a Key that matches my list.

However, this doesn't seem to work. Any advice?

Answer 1

Old post, but I believe a more eloquent solution is

=SUM(SUMIFS(D2:D19,C2:C19,A2:A5))