SUMIFS with multiple OR criterion

Options
Mehran Bagherian
Mehran Bagherian ✭✭✭✭✭

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