diff options
-rw-r--r-- | source/text/scalc/01/04060106.xhp | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index c134e8dbb4..7e42bdcb5b 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -1138,7 +1138,7 @@ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3163656" role="code" xml-lang="en-US">SUM(Number1; Number2; ...; Number30)</paragraph> <paragraph id="par_id3163671" role="paragraph" xml-lang="en-US"><emph>Number1 to Number30</emph> are up to 30 arguments, either cells or ranges, whose sum is to be calculated.</paragraph> -<tip id="par_id151567608802604">SUM ignores any text or empty cell within a range or array. If you suspect wrong results of the SUM function, look for text in the data ranges. Use the <link href="text/scalc/01/03080000.xhp" name="value highllight">value highlighting</link> feature to highlight the text contents in the range that may represent a number.</tip> +<tip id="par_id151567608802604">SUM ignores any text or empty cell within a range or array. If you suspect wrong results of the SUM function, look for text in the data ranges. Use the <link href="text/scalc/01/03080000.xhp" name="value highlight">value highlighting</link> feature to highlight the text contents in the range that may represent a number.</tip> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3163704" role="paragraph" xml-lang="en-US">If you enter the numbers <item type="input">2</item>; <item type="input">3 </item>and <item type="input">4</item> in the Number 1; 2 and 3 text boxes, 9 will be returned as the result.</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. <item type="input">=SUM (A1:E10)</item> calculates the sum of all cells in the A1 to E10 cell range.</paragraph> |