Is there a way to OR the conditions in this SUMIFS expression:
SUMIFS=(A1:A10, B1:B10, "*foo*", B1:B10, "*bar*")You can’t do it using multiple criteria. SUMIFS is defined to perform logical AND on its criteria.
Also you can’t do that using wildcards (which is a primitive tool added and made default for compatibility with MS Office), as you seem to do now. But you may do that using regular expressions (and then you may simplify the formula to use simple SUMIF):
=SUMIF(B1:B10; ".*(foo|bar).*"; A1:A10)