Manuals/calci/CALCI SUM

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.
  • Sum is the operation of adding the sequence of numbers.
  • The mathematical symbol for summation is  
  • The numbers are adding together is called addends or summands.
  • The summation of infinite sequence of values is called a series.
  • 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.

ZOS Section

  • The syntax is to calculate SUM is ZOS is  
  •   are numbers to be added.
  • There are any number of arguments also we can give to find the  .
  • SUM(-20..-10,11..20,30..50)

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