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
Bookmarks