<!DOCTYPE html>
<html lang="en-US">
<head>
<base href="../../../../">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Sum</title>
<link rel="shortcut icon" href="media/navigation/favicon.ico">
<link type="text/css" href="normalize.css" rel="Stylesheet">
<link type="text/css" href="default.css" rel="Stylesheet">
<link type="text/css" href="prism.css" rel="Stylesheet">
<script type="text/javascript" src="polyfills.js"></script><script type="text/javascript" src="languages.js"></script><script type="text/javascript" src="fuzzysort.js"></script><script type="text/javascript" src="prism.js"></script><script type="text/javascript" src="help2.js" defer></script><script type="text/javascript" src="a11y-toggle.js" defer></script><script type="text/javascript" src="en-US/langnames.js" defer></script><script type="text/javascript" src="paginathing.js" defer></script><script type="text/javascript" src="en-US/bookmarks.js" defer></script><script type="text/javascript" src="en-US/contents.js" defer></script><script type="text/javascript" src="help.js" defer></script><meta name="viewport" content="width=device-width,initial-scale=1">
</head>
<body itemscope="true" itemtype="http://schema.org/TechArticle">
<div class="header-extrawurst">
<header><div class="logo-container"><a class="logo" href="en-US/text/shared/05/new_help.html"><div class="symbol"></div>
<p>LibreOffice 6.4 Help</p></a></div></header><div class="modules">
<button type="button" data-a11y-toggle="modules-nav" id="modules" onclick="setupModules('', 'en-US');">Module</button><nav id="modules-nav"></nav>
</div>
</div>
<aside class="rightside"><input id="accordion-1" name="accordion-menu" type="checkbox"><label for="accordion-1">Contents</label><div id="Contents" class="contents-treeview"></div></aside><aside class="leftside"><div id="Index">
<div class="index-label">Index 🔎︎ </div>
<div id="Bookmarks">
<input id="search-bar" type="text" class="search" placeholder="Search in chosen module"><nav class="index"></nav>
</div>
</div></aside><div id="DisplayArea" itemprop="articleBody">
<a name="summe"></a>
<a name="bm_id3157909"></a><meta itemprop="keywords" content="functions,sum function icon">
<meta itemprop="keywords" content="formula bar,sum function">
<meta itemprop="keywords" content="sum icon">
<meta itemprop="keywords" content="AutoSum button, see sum icon">
<a name="bm_id3151384"></a>
<h1 itemprop="articleSection" id="hd_id3157909">Sum</h1>
<p id="par_id3150543" class="paragraph"><span class="avis">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.</span></p>
<a name="sysumme"></a>
<div class="icontable">
<div class="iconcell">
<p id="par_id3153770" class="paragraphintable">
<img src="media/icon-themes/cmd/sc_autosum.svg" class="iconimage" alt="Icon" title="Icon" style="width:16px;height:16px"></p>
</div>
<div class="iconcell">
<p id="par_id3152577" class="paragraphintable">Sum</p>
</div>
</div>
<p id="par_id3156444" class="paragraph">LibreOffice 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.</p>
<p id="par_id3153189" class="paragraph">Click the <span class="emph">Accept</span> icon (green check mark) to use the formula displayed in the input line.</p>
</div>
<div class="search-frame"></div>
<div class="donation-frame"></div>
<footer><div id="DEBUG" class="debug">
<h3 class="bug">Help content debug info:</h3>
<p>This page is: <a href="https://opengrok.libreoffice.org/xref/help/source/text/scalc/02/06030000.xhp" target="_blank">/text/scalc/02/06030000.xhp</a></p>
<p>Title is: Sum</p>
<p id="bm_module"></p>
<p id="bm_system"></p>
<p id="bm_HID"></p>
</div></footer>
</body>
</html>