Bug 151908

Summary:	An error has crept into the documentation of SUMIF().
Product:	LibreOffice	Reporter:	Jürgen Kirsten <dscheikey>
Component:	Documentation	Assignee:	Julien Nabet <serval2412>
Status:	RESOLVED FIXED
Severity:	normal	CC:	79045_79045, mikekaganski, olivier.hallot
Priority:	medium
Version:	6.0.0.3 release
Hardware:	All
OS:	All
Whiteboard:	target:7.5.0
Crash report or crash signature:		Regression By:

Description Jürgen Kirsten 2022-11-04 17:37:22 UTC

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:

Comment 1 Roman Kuznetsov 2022-11-05 12:10:03 UTC

Mike, just for double checking, please look at it. Thanks

Comment 2 Mike Kaganski 2022-11-05 12:28:45 UTC

Indeed, it is the documentation error.

Comment 3 Julien Nabet 2022-11-05 13:33:06 UTC

I submitted this patch on gerrit:
https://gerrit.libreoffice.org/c/help/+/142296

Comment 4 Commit Notification 2022-11-05 18:02:25 UTC

Julien Nabet committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/help/commit/32cbfd80a9053d4f62961edcae6a8b33f5d0bf03

tdf#151908: An error has crept into the documentation of SUMIF()