writer
6,694
edits
Changes
Jump to navigation
Jump to search
Created page with "<div style="font-size:30px">'''SUM(n1,n2,n3...)'''</div><br/> <div style="font-size:30px">'''ADD(n1,n2,n3...)'''</div><br/> *where <math>n_1,n_2,n_3...</math> are the argume..."
<div style="font-size:30px">'''SUM(n1,n2,n3...)'''</div><br/>
<div style="font-size:30px">'''ADD(n1,n2,n3...)'''</div><br/>
*where <math>n_1,n_2,n_3...</math> 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 <math>\sum </math>
*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 <math>+ve</math> or <math>-ve</math>.
*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 <math>n1</math> is required, and from <math>n2,n3...</math>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.
==Examples==
#ADD(1,2,3,4,5,6,7) = 28
#ADD((-20)..0) = -210
#ADD(2.25..34.50..3) = 189.75
==See Also==
*[[Manuals/calci/SUM| SUM]]
*[[Manuals/calci/ADDBY| ADDBY]]
*[[Manuals/calci/AVERAGE| AVERAGE]]
==References==
*[http://en.wikipedia.org/wiki/Summation SUM]
*[[Z_API_Functions | List of Main Z Functions]]
*[[ Z3 | Z3 home ]]
<div style="font-size:30px">'''ADD(n1,n2,n3...)'''</div><br/>
*where <math>n_1,n_2,n_3...</math> 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 <math>\sum </math>
*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 <math>+ve</math> or <math>-ve</math>.
*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 <math>n1</math> is required, and from <math>n2,n3...</math>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.
==Examples==
#ADD(1,2,3,4,5,6,7) = 28
#ADD((-20)..0) = -210
#ADD(2.25..34.50..3) = 189.75
==See Also==
*[[Manuals/calci/SUM| SUM]]
*[[Manuals/calci/ADDBY| ADDBY]]
*[[Manuals/calci/AVERAGE| AVERAGE]]
==References==
*[http://en.wikipedia.org/wiki/Summation SUM]
*[[Z_API_Functions | List of Main Z Functions]]
*[[ Z3 | Z3 home ]]