From 864de3b4e95b4550d7cfdb99ff2188e63f140cd0 Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Sat, 2 Jan 2016 21:48:43 -0200 Subject: Fix typo in AGGREGATE function help page Change-Id: I0701328d135968735bec3b30adeba64fc6138f04 Reviewed-on: https://gerrit.libreoffice.org/21051 Reviewed-by: Olivier Hallot Tested-by: Olivier Hallot --- source/text/scalc/01/func_aggregate.xhp | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/source/text/scalc/01/func_aggregate.xhp b/source/text/scalc/01/func_aggregate.xhp index 13de9725c2..a846bee0d7 100644 --- a/source/text/scalc/01/func_aggregate.xhp +++ b/source/text/scalc/01/func_aggregate.xhp @@ -428,7 +428,7 @@ =AGGREGATE(4;1;A2:A9)
Returns maximum value for the range A2:A9 =34, whereas =MAX(A2:A9) returns the error Err:511.
-=AGGREGATE(9;5;A5:C5)
Returns sum for the range A5:C5 =29, even if the some of the columns are hidden.
+=AGGREGATE(9;5;A5:C5)
Returns sum for the range A5:C5 =29, even if some of the columns are hidden.
=AGGREGATE(9;5;B2:B9)
Returns sum of the column B =115. If any row is hidden, the function omit its value, for example if the 7th row is hidden, the function returns 95.
If you need to apply the function with a 3-D range, this example shows how to do it. =AGGREGATE(13;3;Sheet1.B2:B9:Sheet3.B2:B9)
The function returns mode of the values of second columns through sheets 1:3 (that have the same data) =8.
-- cgit