Hello

When using SUMIFS is there a way you can set the criteria to be one of multiple values?

So in the example below I might want my criteria to be peter or paul. If I put it as a second criteria it has to meet both conditions.

=SUMIFS(B:B,A:A,"Peter")

So where Peter appears how can I say Peter or Paul? Or even better a range of cells


A B
Peter 5
John 6
Paul 7

Thanks