SUMIFS with multiple OR criterion
I am using the function : SUMIFS( range, criterion_range1, criterion1, [ criterion_range2, criterion2... ])
How can I have multiple values for criterion1? I mean, I have multiple values which any one of them will satisfy the requirement, and I want to add all.
E.g. I have a list of many names (in another sheet), each have an amount associated with. Like:
In my second sheet, I need to SUMIFS the quantities if the entry is Sarah OR David