Is there any way to make this OR conditions flexible and using cell references?
=SUMIF(B1:B10; “.(foo|bar).”; A1:A10) (this solution is from here)
instead of “.(foo|bar).”
I am looking for something like C1|C2 (in this case C1=“foo”, C2=“bar”)
I Using Libre Office 6 in Ubuntu but none of my trials made results.
SUMIFS(A$2:A$200;B$2:B$200;C$3:C6;D$2:D$200;"3")
This function using only the value of C6 instead of C3|C4|C5|C6.
With arrays I found also no better result.
Any hint appreciated.