Manuals/calci/SUM

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 $\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, 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.

ZOS

• The syntax is to calculate SUM is ZOS is $SUM()$
• Parameter are numbers to be added.
• There are any number of arguments also we can give to find the $SUM$.
• SUM(-20..-10,11..20,30..50)

Sum

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

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

Related Videos

SUM

See also

• AVERAGE
• PRODUCT

References

SUM

• List of Main Z Functions

• Z3 home