From b5047e08bba1ffff68d3c05213a27138ec41bdea Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Fri, 8 Nov 2019 16:07:20 -0300 Subject: Follow-up patch of 82094 Removed reference of Criterion Change-Id: I8dd11b0a6d44bad183447a344a2e37067fa66c44 Reviewed-on: https://gerrit.libreoffice.org/82322 Tested-by: Jenkins Reviewed-by: Olivier Hallot --- source/text/scalc/01/func_averageif.xhp | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/source/text/scalc/01/func_averageif.xhp b/source/text/scalc/01/func_averageif.xhp index b9e78bcfda..00b9db3a16 100644 --- a/source/text/scalc/01/func_averageif.xhp +++ b/source/text/scalc/01/func_averageif.xhp @@ -33,8 +33,8 @@ Criterion – required argument. A condition in the form of expression or a cell reference with expression that defines what cells should be used to calculate the mean. The expression can contain text, numbers, regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options). Average_Range – optional. It is a range of values for calculating the mean. -Note that if the Average_Range is not specified, Range is used for both, the calculation of the mean and the search according to the condition. If the Average_Range is specified, the Range is used only for the condition test, while Average_Range is used for the mean calculation.
-The Criterion needs to be a string expression, in particular, the Criterion needs to be enclosed in quotation marks ("Criterion") with the exception of the names of functions, cell references and an operation of a string concatenation (&).
+If the Average_Range is not specified, Range is used for both, the calculation of the mean and the search according to the condition. If Average_Range is specified, the Range is used only for the condition test, while Average_Range is used for the average calculation. + If a cell in a range of values for calculating the mean is empty or contains text, function AVERAGEIF ignores this cell.
If the whole range is empty, contains only text or all values of the range do not satisfy the condition (or any combination of those), the function returns the #DIV/0! error.
-- cgit