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

[PATSYS]

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

 

[barry houdini]

It depends exactly what you want but you can use something like

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

 

[PATSYS]

It depends exactly what you want but you can use something like

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

Whew, terrific. Thanks!