From 32cbfd80a9053d4f62961edcae6a8b33f5d0bf03 Mon Sep 17 00:00:00 2001 From: Julien Nabet Date: Sat, 5 Nov 2022 15:29:43 +0200 Subject: tdf#151908: An error has crept into the documentation of SUMIF() Change-Id: Ifbaab9ecc270db4f70c6b4937c30c7d88f0547d4 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/142296 Tested-by: Jenkins Reviewed-by: Julien Nabet --- source/text/scalc/01/04060106.xhp | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'source') diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index 753b9f1315..8ff3017000 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -1001,7 +1001,7 @@ Range is the range to which the criterion is to be applied. SumRange is the range from which values are summed. If this parameter has not been indicated, the values found in the Range are summed. -SUMIF supports the reference concatenation operator (~) only in the Criterion parameter, and only if the optional SumRange parameter is not given. +SUMIF supports the reference concatenation operator (~) only in the Range parameter, and only if the optional SumRange parameter is not given. To sum up only negative numbers: =SUMIF(A1:A10;"<0") -- cgit