[Libreoffice-bugs] [Bug 131927] New: Help fails to explain varibale use of criteria parameter in sumif()
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Mon Apr 6 11:11:43 UTC 2020
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>
More information about the Libreoffice-bugs
mailing list