# Manuals/calci/ADD

Jump to navigation
Jump to search

**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
- 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 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

- It is empty cells
- It is logical values
- It is text.

- This function shows error value when the arguments cannot be changed to numbers.

## Examples

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

## Related Videos

## See Also

## References