Difference between revisions of "Manuals/calci/SUM"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | <div | + | <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. | |
| − | + | ==Description== | |
| + | *This function gives the total sum value of given arguments. | ||
| + | *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== | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | + | !Equation | |
| − | + | | n1 | |
| − | | | + | | n2 |
| − | | | + | | n3 |
| − | | | + | | SUM |
| − | | | ||
|- class="odd" | |- class="odd" | ||
| − | | | + | |SUM(1,2,3) |
| − | + | | 1 | |
| − | + | | 2 | |
| − | | | + | | 3 |
| − | + | | 6 | |
|- class="even" | |- class="even" | ||
| − | | | + | | SUM(5,-9,45) |
| − | | | + | | 5 |
| − | | | + | | -9 |
| − | | | + | | 45 |
| − | | | + | | 41 |
|- class="odd" | |- class="odd" | ||
| − | | | + | | SUM(A1:A3) |
| − | | | + | | CELL A1 |
| − | | | + | | CELL A2 |
| − | | | + | | CELL A3 |
| − | | | + | | A1+A2+A3 |
|- class="even" | |- class="even" | ||
| − | + | ||
| − | | | + | |} |
| − | + | ||
| − | + | ==See also== | |
| − | + | ||
| − | + | *[[Manuals/calci/AVERAGE| AVERAGE]] | |
| − | + | *[[Manuals/calci/PRODUCT| PRODUCT]] | |
| − | + | ||
| − | | | + | ==References== |
| − | | | + | [http://en.wikipedia.org/wiki/Summation SUM] |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 06:19, 22 November 2013
SUM(n1,n2,n3...)
- where are the arguments for which to find the total.
are the arguments for which to find the total.Description
- This function gives the total sum value of given arguments.
- 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
or 
.
is required, and from 
it is optional.- 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
| 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 |