Calc: How to "OR" conditions in SUMIFS?
Is there a way to OR the conditions in this SUMIFS expression:
SUMIFS=(A1:A10, B1:B10, "*foo*", B1:B10, "*bar*")
add a comment
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)
Asked: 2020-01-01 09:32:10 +0100
Seen: 451 times
Last updated: Jan 01 '20
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.