1*cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2*cdf0e10cSrcweir<helpdocument version="1.0"> 3*cdf0e10cSrcweir 4*cdf0e10cSrcweir<!-- 5*cdf0e10cSrcweir*********************************************************************** 6*cdf0e10cSrcweir * 7*cdf0e10cSrcweir * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 8*cdf0e10cSrcweir * 9*cdf0e10cSrcweir * Copyright 2000, 2010 Oracle and/or its affiliates. 10*cdf0e10cSrcweir * 11*cdf0e10cSrcweir * OpenOffice.org - a multi-platform office productivity suite 12*cdf0e10cSrcweir * 13*cdf0e10cSrcweir * This file is part of OpenOffice.org. 14*cdf0e10cSrcweir * 15*cdf0e10cSrcweir * OpenOffice.org is free software: you can redistribute it and/or modify 16*cdf0e10cSrcweir * it under the terms of the GNU Lesser General Public License version 3 17*cdf0e10cSrcweir * only, as published by the Free Software Foundation. 18*cdf0e10cSrcweir * 19*cdf0e10cSrcweir * OpenOffice.org is distributed in the hope that it will be useful, 20*cdf0e10cSrcweir * but WITHOUT ANY WARRANTY; without even the implied warranty of 21*cdf0e10cSrcweir * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 22*cdf0e10cSrcweir * GNU Lesser General Public License version 3 for more details 23*cdf0e10cSrcweir * (a copy is included in the LICENSE file that accompanied this code). 24*cdf0e10cSrcweir * 25*cdf0e10cSrcweir * You should have received a copy of the GNU Lesser General Public License 26*cdf0e10cSrcweir * version 3 along with OpenOffice.org. If not, see 27*cdf0e10cSrcweir * <http://www.openoffice.org/license.html> 28*cdf0e10cSrcweir * for a copy of the LGPLv3 License. 29*cdf0e10cSrcweir * 30*cdf0e10cSrcweir ************************************************************************ 31*cdf0e10cSrcweir --> 32*cdf0e10cSrcweir 33*cdf0e10cSrcweir 34*cdf0e10cSrcweir<meta> 35*cdf0e10cSrcweir <topic id="textscalc0206030000xml" indexer="include" status="PUBLISH"> 36*cdf0e10cSrcweir <title xml-lang="en-US" id="tit">Sum</title> 37*cdf0e10cSrcweir <filename>/text/scalc/02/06030000.xhp</filename> 38*cdf0e10cSrcweir </topic> 39*cdf0e10cSrcweir </meta> 40*cdf0e10cSrcweir <body> 41*cdf0e10cSrcweir <section id="summe"> 42*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3157909"><bookmark_value>functions;sum function icon</bookmark_value> 43*cdf0e10cSrcweir <bookmark_value>formula bar;sum function</bookmark_value> 44*cdf0e10cSrcweir <bookmark_value>sum icon</bookmark_value> 45*cdf0e10cSrcweir <bookmark_value>AutoSum button, see sum icon</bookmark_value> 46*cdf0e10cSrcweir</bookmark> 47*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_INSWIN_SUMME" id="bm_id3151384" localize="false"/><comment>MW inserted a cross-reference</comment> 48*cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3157909" role="heading" level="1" l10n="U" oldref="1"><link href="text/scalc/02/06030000.xhp" name="Sum">Sum</link></paragraph> 49*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3150543" role="paragraph" l10n="CHG" oldref="2"><ahelp hid="HID_INSWIN_SUMME">Inserts the sum of a cell range into the current cell, or inserts sum values into selected cells. Click in a cell, click this icon, and optionally adjust the cell range. Or select some cells into which the sum values will be inserted, then click the icon.</ahelp></paragraph> 50*cdf0e10cSrcweir </section> 51*cdf0e10cSrcweir <section id="sysumme"> 52*cdf0e10cSrcweir <table id="tbl_id3150868"> 53*cdf0e10cSrcweir <tablerow> 54*cdf0e10cSrcweir <tablecell> 55*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3153770" role="paragraph" l10n="E"> 56*cdf0e10cSrcweir<image id="img_id3147434" src="res/commandimagelist/sc_autosum.png" width="0.1665in" height="0.1665in"><alt xml-lang="en-US" id="alt_id3147434">Icon</alt> 57*cdf0e10cSrcweir </image></paragraph> 58*cdf0e10cSrcweir </tablecell> 59*cdf0e10cSrcweir <tablecell> 60*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3152577" role="paragraph" l10n="U" oldref="15">Sum</paragraph> 61*cdf0e10cSrcweir </tablecell> 62*cdf0e10cSrcweir </tablerow> 63*cdf0e10cSrcweir </table> 64*cdf0e10cSrcweir 65*cdf0e10cSrcweir </section> 66*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3156444" role="paragraph" l10n="U" oldref="16">$[officename] automatically suggests a cell range, provided that the spreadsheet contains data. If the cell range already contains a sum function, you can combine it with the new one to yield the total sum of the range. If the range contains filters, the Subtotal function is inserted instead of the Sum function.</paragraph> 67*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3153189" role="paragraph" l10n="U" oldref="3">Click the <emph>Accept</emph> icon (green check mark) to use the formula displayed in the input line.</paragraph> 68*cdf0e10cSrcweir </body> 69*cdf0e10cSrcweir</helpdocument>
