Manuals/calci/CALCI SUM

SUM(n1,n2,n3...)

• where $n1,n2,n3..$ are the arguments for which to find the total.

Description

• This function gives the total sum value of given arguments.
• The argument may be any type of numbers like '+' or '-'.
• Also in arguments 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.
• Here we must give more than one argument. i.e n1 is required, and from n2 ,n3....
• it is optional up to any number of arguments we can give.
• while giving the arguments is an array or reference only the constants are considered.
• The arguments are ignored if it is are empty cells,logical values or text.
• This function shows error value when the arguments cannot change in to numbers.

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

See also

• AVERAGE
• PRODUCT

References

SUM