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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
