Difference between revisions of "Manuals/calci/SUM"
Jump to navigation
Jump to search
| Line 14: | Line 14: | ||
SUM(number1, [number2], [number3], [number4], ...) | SUM(number1, [number2], [number3], [number4], ...) | ||
| − | |||
| − | |||
<div id="8SpaceContent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman">''''''''''''<font size="6"> </font>''' '''''''''</font>'''</div></div> | <div id="8SpaceContent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman">''''''''''''<font size="6"> </font>''' '''''''''</font>'''</div></div> | ||
| Line 25: | Line 23: | ||
</div></div> | </div></div> | ||
| + | |||
---- | ---- | ||
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman"> <font size="6">SUM</font> </font>'''</div></div> | <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman"> <font size="6">SUM</font> </font>'''</div></div> | ||
| + | |||
| + | |||
---- | ---- | ||
<div id="3SpaceContent" class="zcontent" align="left"><br /><div id="7Space" class="gamizbox" title="7Space"><div id="7SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="7SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="7SpaceRollupContent" align="center"></span></span></div><div id="7SpaceCover"><div id="7SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="3" face="Times New Roman"> </font>'''SUM'''(n1,n2, ...) | <div id="3SpaceContent" class="zcontent" align="left"><br /><div id="7Space" class="gamizbox" title="7Space"><div id="7SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="7SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="7SpaceRollupContent" align="center"></span></span></div><div id="7SpaceCover"><div id="7SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="3" face="Times New Roman"> </font>'''SUM'''(n1,n2, ...) | ||
| Line 39: | Line 40: | ||
</div></div> | </div></div> | ||
| + | |||
---- | ---- | ||
<div id="12SpaceContent" class="zcontent" align="left"><br /><br /><br /><div id="9Space" class="gamizbox" title="9Space"><div id="9SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="9SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="9SpaceRollupContent" align="center"></span></span></div><div id="9SpaceCover"><div id="9SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="2"><font color="#484848"><font face="Arial">=SUM(2,4) = 6</font></font></font> | <div id="12SpaceContent" class="zcontent" align="left"><br /><br /><br /><div id="9Space" class="gamizbox" title="9Space"><div id="9SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="9SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="9SpaceRollupContent" align="center"></span></span></div><div id="9SpaceCover"><div id="9SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="2"><font color="#484848"><font face="Arial">=SUM(2,4) = 6</font></font></font> | ||
Revision as of 11:21, 15 November 2013
.
Sum Function:- The operation of adding a sequence of numbers; the result is their sum or total
Syntax
SUM(number1, [number2], [number3], [number4], ...)
''''''' ''''
Description
SUM
SUM(n1,n2, ...)
Will calculate total value of parameters n1, n2 etc
Adds all the numbers in a range of cells.
=SUM(2,4) = 6
=SUM(2,”4”,TRUE) = 6
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 2 | 3 | ||
| Row2 | 8 | 7 | ||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
