source/text/scalc/01/func_sum.xhp | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 09fd472db2c23c40da053606953449cc165d6ecf
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Mon Mar 13 09:31:44 2023 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Mon Mar 13 12:37:21 2023 +0000
Fix bad link
Change-Id: I1943382ae49c3085e8619c1b2d99c7be3c76e35f
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/148786
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/func_sum.xhp
b/source/text/scalc/01/func_sum.xhp
index c67b55a555..3aef7d8edf 100644
--- a/source/text/scalc/01/func_sum.xhp
+++ b/source/text/scalc/01/func_sum.xhp
@@ -34,7 +34,7 @@
<paragraph id="par_id3163704" role="paragraph"
xml-lang="en-US"><input>=SUM(2;3;4)</input> returns 9.</paragraph>
<paragraph id="par_id3151740" role="paragraph" xml-lang="en-US"><item
type="input">=SUM(A1;A3;B5)</item> calculates the sum of the three
cells.</paragraph>
<paragraph id="par_id931636109030406" role="paragraph"
xml-lang="en-US"><item type="input">=SUM(A1:E10)</item> calculates the sum of
all cells in the A1 to E10 cell range.</paragraph>
- <paragraph id="par_id3151756" role="paragraph" xml-lang="en-US">A formula
such as <input>=SUM((A1:A40>=C1)*(A1:A40<C2)*B1:B40)</input> may be
entered as an <link href="text/scalc/01/04060107.html#hd_id3148474">array
formula</link> by pressing the Shift<switchinline select="sys"><caseinline
select="MAC">+Command</caseinline><defaultinline>+Ctrl</defaultinline></switchinline>+Enter
keys instead of simply pressing the Enter key to finish entering the formula.
The formula will then be shown in the Formula bar enclosed in braces and
operates by multiplying corresponding elements of the arrays together and
returning their sum.</paragraph>
+ <paragraph id="par_id3151756" role="paragraph" xml-lang="en-US">A formula
such as <input>=SUM((A1:A40>=C1)*(A1:A40<C2)*B1:B40)</input> may be
entered as an <link href="text/scalc/01/04060107.xhp">array formula</link> by
pressing the Shift<switchinline select="sys"><caseinline
select="MAC">+Command</caseinline><defaultinline>+Ctrl</defaultinline></switchinline>+Enter
keys instead of simply pressing the Enter key to finish entering the formula.
The formula will then be shown in the Formula bar enclosed in braces and
operates by multiplying corresponding elements of the arrays together and
returning their sum.</paragraph>
<section id="relatedtopics">
<tip id="par_id771677014538669"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUM";>SUM
wiki page</link>.</tip>
