Difference between revisions of "Manuals/calci/CALCI SUM"
Jump to navigation
Jump to search
| Line 18: | Line 18: | ||
{| 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 |
| − | + | ||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | | | + | | |
| − | | | + | | |
| | | | ||
| | | | ||
Revision as of 07:48, 11 November 2013
CALCI_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 | |
| Row4 | ||||
| Row5 | ||||
| Row6 |
