SUMIFS with multiple OR criterion

Options

Hello there,

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:

David; 25

John; 23

Sarah; 15

Steve; 46

Mark; 34


In my second sheet, I need to SUMIFS the quantities if the entry is Sarah OR David

Answers