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*")
First time here? Check out the FAQ!
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)
Asked: 2020-01-01 09:32:10 +0100
Seen: 451 times
Last updated: Jan 01 '20
How do I export a chart in an image format from LibreOffice Calc? [closed]
Are there plans for a "papercut" project for libreoffice [closed]
Is it normal for Calc goal seek to take very long? [closed]
Please refine "Search" in Calc - implement functions in Gnumeric [closed]
LibreOffice Calc will not link to external data via internet [closed]
Is there a LibreOffice .odt, .ods viewer for Android? [closed]
Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]