(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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 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.