# How to sumif using more than 1 criteria (OR not AND)

#### PATSYS

##### Well-known Member
I am aware of the sumproduct & sum(if) array formula but these are using the operator AND between the criteria (meaning all criteria met).

I would like to know if there is a way to sum if just one of the criteria is met (e.g. OR)?

One option is of course to i.e. sumif()+sumif(), etc but I am thinking there might be a smarter way?

Thanks

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

#### barry houdini

##### MrExcel MVP
It depends exactly what you want but you can use something like

=SUM(SUMIF(A1:A10,{"apple","orange"},B1:B10))

#### PATSYS

##### Well-known Member
It depends exactly what you want but you can use something like

=SUM(SUMIF(A1:A10,{"apple","orange"},B1:B10))

Whew, terrific. Thanks!

Replies
10
Views
625
Replies
5
Views
450
Replies
3
Views
259
Replies
2
Views
242
Replies
1
Views
604

1,171,240
Messages
5,874,604
Members
433,060
Latest member
studyiqedu

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back