# Manuals/calci/SUM

Jump to navigation
Jump to search

**SUM()**

- Parameters are the arguments for which to find the total.
- SUM(), 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, 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

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

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

## ZOS

- The syntax is to calculate SUM is ZOS is
- Parameter 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 |

- SUM(2...10000000...6) = 4031078
- SUM(1..10.$(x=>x^3)) = 3025
- SUM((1..10)^3) = 3025
- n=100;SUM((1..n)^3) = 25502500

## Related Videos

## See also

## References