From ZCubes Wiki
Revision as of 14:42, 30 May 2017 by Devika (talk | contribs) (Created page with "<div style="font-size:30px">'''SUM(n1,n2,n3...)'''</div><br/> <div style="font-size:30px">'''ADD(n1,n2,n3...)'''</div><br/> *where <math>n_1,n_2,n_3...</math> are the argume...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search


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


  • 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.


  1. ADD(1,2,3,4,5,6,7) = 28
  2. ADD((-20)..0) = -210
  3. ADD(2.25..34.50..3) = 189.75

See Also