Difference between revisions of "Manuals/calci/CALCI SUM"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
<div style="font-size:30px">'''SUM(n1,n2,n3...)'''</div><br/> | <div style="font-size:30px">'''SUM(n1,n2,n3...)'''</div><br/> | ||
− | *where <math>n1,n2,n3..</math> are the arguments for which to find the total. | + | *where <math>n1,n2,n3...</math> are the arguments for which to find the total. |
==Description== | ==Description== | ||
Line 7: | Line 7: | ||
*The arguments can be '+ve' or '-ve'. | *The arguments can be '+ve' or '-ve'. | ||
*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. | *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. | + | *Here we must give more than 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. | *The arguments can be up to any number. | ||
*If the arguments is an array or reference, only the constants are considered. | *If the arguments is an array or reference, only the constants are considered. |
Revision as of 06:21, 19 November 2013
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.
- The arguments can be '+ve' or '-ve'.
- 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 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 it is empty cells,logical values or text.
- This function shows error value when the arguments cannot be changed 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 |