[Libreoffice-bugs] [Bug 144889] SUMIFS

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=144889

--- Comment #3 from Mike Kaganski <mikekaganski at hotmail.com> ---
In addition to comment 2:

Ref: relevant help page
https://help.libreoffice.org/latest/en-US/text/scalc/01/func_sumifs.html?DbPAR=CALC

> The logical relation between criteria can be defined as logical AND (conjunction).
> In other words, if and only if all given criteria are met, a value from the
> corresponding cell of the given Func_Range is taken into calculation.

There you may also find something to resolve your "additional" confusion:

> Regex expressions should be like any other software, "*" alone doesn't mean
> anything, it should have something before it, for example:
> .*
> a*
> [1-9]*
> etc

What you see are *not* "regular expressions". By default, wildcards are enabled
in Options/Calc/Caclulate. They have different simplified syntax.

Ref:
https://help.libreoffice.org/7.3/en-US/text/scalc/guide/wildcards.html?DbPAR=CALC

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20211003/b415cda6/attachment.htm>