diff options
| author | Steve Fanning <stevemfanning@yahoo.co.uk> | 2021-11-10 13:14:38 +0200 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2021-11-10 13:22:08 +0100 |
| commit | 99120cbfb9b5c0c75bc1b3317fa87ecab58d170a (patch) | |
| tree | 2f5fe74b0e97edc614a39d18dea798bed457dbe4 | |
| parent | 9077a2887221677690282917c66c7af8e3e37121 (diff) | |
Update help page for Calc's Mathematical Functions to remove detail about SUM() function.
Leave just a link and a one line overview. This is a follow-up to change https://gerrit.libreoffice.org/c/help/+/124696.
Change-Id: I31898c9f8d1fc0dca83a7d3fc12d466a3d50928c
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/124865
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
| -rw-r--r-- | source/text/scalc/01/04060106.xhp | 24 |
1 files changed, 3 insertions, 21 deletions
diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index a245b9d28f..c046147454 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -1017,27 +1017,9 @@ <embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/> </section> -<section id="Section16"> -<bookmark xml-lang="en-US" branch="index" id="bm_id3163596"> - <bookmark_value>SUM function</bookmark_value> - <bookmark_value>adding;numbers in cell ranges</bookmark_value> -</bookmark> -<comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMME" id="bm_id3163608" localize="false"/> - -<h2 id="hd_id3163596"><variable id="sum_head"><link href="text/scalc/01/04060106.xhp#Section16">SUM</link></variable></h2> -<paragraph id="par_id3163625" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SUMME">Adds a set of numbers.</ahelp></paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id3163656" role="code" xml-lang="en-US">SUM(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> -<embed href="text/scalc/01/ful_func.xhp#number255"/> -<embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<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" name="ARRAY_FORMULA">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> -<tip id="par_id661636108218550">Refer to the <link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUM" name="SUM_Wiki">SUM</link> wiki page for more details about this function.</tip> +<section id="sum"> + <h2 localize="false" id="hd_id841636542200276"><embedvar href="text/scalc/01/func_sum.xhp#sum_head"/></h2> + <paragraph id="par_id301636542246396" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/scalc/01/func_sum.xhp#func_sum_desc"/></paragraph> </section> <section id="Section15"> |