Difference between revisions of "Manuals/calci/SUM"

From ZCubes Wiki
Jump to navigation Jump to search
Line 11: Line 11:
  
 
</div></div>
 
</div></div>
----
 
 
<div id="14SpaceContent" class="zcontent" align="left"><br /><br /><br /><div id="5Space" class="gamizbox" title="5Space"><div id="5SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="5SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="5SpaceRollupContent" align="center"></span></span></div><div id="5SpaceCover"><div id="5SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">
 
<div id="14SpaceContent" class="zcontent" align="left"><br /><br /><br /><div id="5Space" class="gamizbox" title="5Space"><div id="5SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="5SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="5SpaceRollupContent" align="center"></span></span></div><div id="5SpaceCover"><div id="5SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">
  
Line 18: Line 17:
 
</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 12:29, 15 November 2013

. 


The operation of adding a sequence of numbers; the result is their sum or total

Sum(number1, [number2], [number3], [number4], ...)

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