Difference between revisions of "Manuals/calci/CALCI SUM"

From ZCubes Wiki
Jump to navigation Jump to search
Line 1: Line 1:
 
<div style="font-size:30px">'''SUM(n1,n2,n3...)'''</div><br/>
 
<div style="font-size:30px">'''SUM(n1,n2,n3...)'''</div><br/>
  
*where <math>n1,n2,n3..</math> are  the arguments for which to find the total.
+
*where <math>n1,n2,n3...</math> are  the arguments for which to find the total.
  
 
==Description==
 
==Description==
Line 7: Line 7:
 
*The arguments can be '+ve' or '-ve'.  
 
*The arguments can be '+ve' or '-ve'.  
 
*Also in arguments, we can give any cell references like column or row number, logical values like true or false, an array, or a result from any other functions.  
 
*Also in arguments, we can give any cell references like column or row number, logical values like true or false, an array, or a result from any other functions.  
*Here we must give more than one argument. i.e n1 is required, and from n2 ,n3... it is optional.
+
*Here we must give more than one argument. i.e <math>n1</math> is required, and from <math>n2,n3...</math>it is optional.
 
*The arguments can be up to any number.
 
*The arguments can be up to any number.
 
*If the  arguments is an array or reference, only the constants are considered.  
 
*If the  arguments is an array or reference, only the constants are considered.  

Revision as of 07:21, 19 November 2013

SUM(n1,n2,n3...)


  • where are the arguments for which to find the total.

Description

  • This function gives the total sum value of given arguments.
  • The arguments can be '+ve' or '-ve'.
  • Also in arguments, we can give any cell references like column or row number, logical values like true or false, an array, or a result from any other functions.
  • Here we must give more than one argument. i.e is required, and from it is optional.
  • The arguments can be up to any number.
  • If the arguments is an array or reference, only the constants are considered.
  • The arguments are ignored, if it is empty cells,logical values or text.
  • This function shows error value when the arguments cannot be changed to numbers.

Examples

Equation n1 n2 n3 SUM
SUM(1,2,3) 1 2 3 6
SUM(5,-9,45) 5 -9 45 41
SUM(A1:A3) CELL A1 CELL A2 CELL A3 A1+A2+A3

See also

References

SUM