Difference between revisions of "Manuals/calci/SUM"

From ZCubes Wiki
Jump to navigation Jump to search
Line 9: Line 9:
  
 
Will calculate total value of  parameters n1, n2 etc
 
Will calculate total value of  parameters n1, n2 etc
 
</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">
 
  
 
Adds all the numbers in a range of cells.
 
Adds all the numbers in a range of cells.

Revision as of 12:30, 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