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

From ZCubes Wiki
Jump to navigation Jump to search
Line 5: Line 5:
 
==Description==
 
==Description==
 
*This function gives the total sum value of given arguments.
 
*This function gives the total sum value of given arguments.
*The arguments can be '+ve' or '-ve'.  
+
*The arguments can be <math>+ve</math> or <math>-ve</math>.  
*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.  
+
*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 in Arguments.  
*Here we must give more than one argument. i.e <math>n1</math> is required, and from <math>n2,n3...</math>it is optional.
+
*We must give atleast 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.  
*The arguments are ignored, if it is empty cells,logical values or text.  
+
*The arguments are ignored, if  
 +
# It is empty cells
 +
# It is logical values
 +
# It is text.  
 
*This function shows error value when the arguments cannot be changed to numbers.
 
*This function shows error value when the arguments cannot be changed to numbers.
  

Revision as of 00:58, 20 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 or .
  • 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 in Arguments.
  • We must give atleast 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
  1. It is empty cells
  2. It is logical values
  3. It is 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