SumIFs, using a list as possible criteria...

  A      B         C 
Joe    10       Joe
Mike   9        Mike
Fred   20      Tom
Sam   3
Mike   2
Sam   10

That is how my data looks. Basically I want to add a cell that will sum the values of B, if the name in A is also in C. Something like...

=SumIfs(b:b,a:a,{ANYTHING IN C})

I also need to be able to add more values to C and have them included automatically, but I don't think that would be a problem.

Thanks