Difference between revisions of "Manuals/calci/SUM"

From ZCubes Wiki
Jump to navigation Jump to search
Line 3: Line 3:
  
 
<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify">
 
<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify">
Sum Function:-
+
Sum(number1, [number2], [number3], [number4], ...)
 +
 
 +
 
 
The operation of adding a sequence of numbers; the result is their sum or total
 
The operation of adding a sequence of numbers; the result is their sum or total
  

Revision as of 12:24, 15 November 2013

. 


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


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


Syntax

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



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