diff options
| -rw-r--r-- | source/text/scalc/01/func_aggregate.xhp | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/source/text/scalc/01/func_aggregate.xhp b/source/text/scalc/01/func_aggregate.xhp index a18f0b4765..9e33cf7ded 100644 --- a/source/text/scalc/01/func_aggregate.xhp +++ b/source/text/scalc/01/func_aggregate.xhp @@ -421,7 +421,7 @@ </tablerow> </table> -<paragraph id="par_id230920152006414" role="paragraph" xml-lang="en-US"><item type="input">=AGGREGATE(4;2;A2:A9)</item><br/>Returns maximum value for the range A2:A9 = 34, whereas <item type="input">=MAX(A2:A9)</item> returns the error Err:511.</paragraph> +<paragraph id="par_id230920152006414" role="paragraph" xml-lang="en-US"><item type="input">=AGGREGATE(4;2;A2:A9)</item><br/>Returns maximum value for the range A2:A9 = 34.</paragraph> <paragraph id="par_id2309201520064180" role="paragraph" xml-lang="en-US"><item type="input">=AGGREGATE(9;5;A5:C5)</item><br/>Returns sum for the range A5:C5 = 29, even if some of the columns are hidden.</paragraph> <paragraph id="par_id2309201520064118" role="paragraph" xml-lang="en-US"><item type="input">=AGGREGATE(9;5;B2:B9)</item><br/>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.</paragraph> <paragraph id="par_id196152404026557" role="paragraph" xml-lang="en-US">If you need to apply the function with a 3D range, this example shows how to do it.</paragraph> |