Ask Your Question

Calc: How to "OR" conditions in SUMIFS?

asked 2020-01-01 09:32:10 +0100

BeOS gravatar image

updated 2020-09-08 15:26:29 +0100

Alex Kemp gravatar image

Is there a way to OR the conditions in this SUMIFS expression:

SUMIFS=(A1:A10, B1:B10, "*foo*", B1:B10, "*bar*")
edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-01-01 10:29:50 +0100

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)
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-01-01 09:32:10 +0100

Seen: 451 times

Last updated: Jan 01 '20