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:
Mike, just for double checking, please look at it. Thanks
Indeed, it is the documentation error.
I submitted this patch on gerrit: https://gerrit.libreoffice.org/c/help/+/142296
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()