Bug 131927

Summary: Help fails to explain variable use of criteria parameter in sumif()
Product: LibreOffice Reporter: Burg <breg>
Component: DocumentationAssignee: Not Assigned <libreoffice-bugs>
Status: ASSIGNED ---    
Severity: enhancement CC: ming.v.hua, olivier.hallot
Priority: medium    
Version: 6.4.2.2 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 120200    

Description Burg 2020-04-06 11:11:43 UTC 
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.
Comment 1 Ming Hua 2020-05-02 11:58:46 UTC 
Since you are talking about the English help text, it sounds like a documentation issue instead of a localization one to me.

Let's change the component and ping the documentation people and see what they say.
Comment 2 Burg 2020-05-02 13:56:50 UTC 
Fine with me, I did not see the 'documentation' option.
Comment 3 Buovjaga 2020-08-24 19:56:58 UTC 
Ok, the section is https://help.libreoffice.org/latest/en-US/text/scalc/01/04060106.html#Section15

If you want, you can propose the explanation that should be added and the location of where it should be inserted.
Comment 4 fpy 2024-03-15 11:19:05 UTC 
I guess the point here is just that only 1 example is given,
because the text clearly says :  A criterion is a *single cell Reference*, Number or Text


For the sake of closing this "bug", I'm adding a link to COUNTIF, to emphasize it  gives more examples.

See also many more examples here :
https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUMIF
Comment 5 Burg 2024-03-16 14:13:03 UTC 
R U Sirius? 
Four years after reporting this deficiency in the help files, the best solution is to add a link to another function with the same situation?

Help is there to -explain-, not to give examples.
Add the proposed text, then you can close this bug.