[Libreoffice-bugs] [Bug 131927] New: Help fails to explain varibale use of criteria parameter in sumif()

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 131927
           Summary: Help fails to explain varibale use of criteria
                    parameter in sumif()
           Product: LibreOffice
           Version: 6.4.2.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Localization
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: breg at kanka.de

The sumif() function allows cell reference in its 'criteria' parameter, like:

SUMIF(G4:G66;"="&G68;D4:D66)
where G68 contains the index, for example numbers 1,2,3.
According to the (en) help each function needed specific "=1", "=2" and "=3"
criteria.
I only found the above solution in online forums - for Excel ;-) - but it works
also in LO.

Solution: Add the ".."&cell-reference  Option to the Help text.

-- 
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/20200406/b6d56b35/attachment-0001.htm>