Difference between revisions of "Manuals/calci/CALCI SUM"

From ZCubes Wiki
Jump to navigation Jump to search
Line 42: Line 42:
 
| A1+A2+A3
 
| A1+A2+A3
 
|- class="even"
 
|- class="even"
| Row4
+
 
|
 
|
 
|
 
| class="  " |
 
|- class="odd"
 
| class=" " | Row5
 
|
 
|
 
|
 
|
 
|- class="even"
 
| Row6
 
|
 
|
 
|
 
|
 
 
|}
 
|}
  

Revision as of 04:49, 12 November 2013

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 41
SUM(A1:A3) CELL A1 CELL A2 CELL A3 A1+A2+A3

See also

References

SUM