Manuals/calci/ADD

SUM()

ADD()

• Parameters are any set of arguments for which to find the total.
  • ADD() adds its arguments.

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 $\sum$
• 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 $+ve$ or $-ve$.
• 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 at least one argument. i.e First parameter is required, and from second parameter are 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

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

Related Videos

Sum

See Also

• SUM
• ADDBY
• AVERAGE

References

• SUM

• List of Main Z Functions
• Z3 home