https://bugs.documentfoundation.org/show_bug.cgi?id=151908
Bug ID: 151908
Summary: An error has crept into the documentation of SUMIF().
Product: LibreOffice
Version: 6.0.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Documentation
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Description:
In the documentation of the SUMIF() function there is a tip in a green box. The
following text can be found there:
SUMIF supports the reference concatenation operator (~) only in the Criterion
parameter, and only if the optional SumRange parameter is not given.
In my opinion, the text should correctly read:
SUMIF supports the reference concatenation operator (~) only in the Range
parameter, and only if the optional SumRange parameter is not given.
Here is the link to the current help page for SUMIF().
https://help.libreoffice.org/latest/en-US/text/scalc/01/04060106.html?&DbPAR=CALC&System=WIN#Section15
This error has been present since Help Page 6.0.
I have tried the function with the concatenation operator in Range. This is how
it works. I cannot use concatenated ranges in the Criteria parameter.
Actual Results:
Expected Results:
Reproducible: Always
User Profile Reset: No
Additional Info:
--
You are receiving this mail because:
You are the assignee for the bug.
