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

From ZCubes Wiki
Jump to navigation Jump to search
 
(23 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
<div style="font-size:30px">'''CALCI_SUM(n1,n2,n3)'''</div><br/>
+
<div style="font-size:30px">'''SUM(n1,n2,n3...)'''</div><br/>
  
−
*where n1,n2,n3.. 'are  the arguments for which to find the total.
+
*where <math>n_1,n_2,n_3...</math> are  the arguments for which to find the total.
  
 
==Description==
 
==Description==
 +
 
*This function gives the total sum value of given arguments.
 
*This function gives the total sum value of given arguments.
−
*The argument may be any type of numbers like '+' or '-'.  
+
*Sum is the operation of adding the sequence of numbers.
−
*Also in arguments  we can give any cell references like column or row number,
+
*The mathematical symbol for summation is <math>\sum </math>
−
*logical values like true or false, an array, or a result from any other functions.  
+
*The numbers are adding together is called addends or summands.
−
*Here we must give more than one argument. i.e n1 is required, and from n2 ,n3....  
+
*The summation of infinite sequence of values is called a series.
−
*it is optional up to any number of arguments we can give.
+
*The arguments can be <math>+ve</math> or <math>-ve</math>.  
−
*while giving the arguments is an array or reference only the constants are considered.  
+
*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.  
−
*The arguments are ignored if it is are empty cells,logical values or text.  
+
*We must give atleast one argument. i.e <math>n1</math> is required, and from <math>n2,n3...</math>it is optional.
−
*This function shows error value when the arguments cannot change in to numbers.
+
*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.
  
 +
==ZOS Section==
  
−
*COMPLEX(RN,IN,S)
+
*The syntax is to calculate SUM is ZOS is <math>SUM(a,b,...)</math>
−
*=COMPLEX(5,2) is 5+2i
+
*<math> a,b,..</math> are numbers to be added.
−
*=COMPLEX(5,2,"j") is 5+2j
+
*There are any number of arguments also we can give to find the <math> SUM </math>.
 +
*SUM(-20..-10,11..20,30..50)
 +
{{#ev:youtube|8iJutK_1nS4|280|center|Sum}}
  
 
==Examples==
 
==Examples==
Line 24: Line 33:
 
{| id="TABLE3" class="SpreadSheet blue"
 
{| id="TABLE3" class="SpreadSheet blue"
 
|- class="even"
 
|- class="even"
−
| class=" " |
+
!Equation
−
| Column1
+
| n1
−
| class="  " | Column2
+
| n2
−
| Column3
+
| n3
−
| Column4
+
| SUM
 
|- class="odd"
 
|- class="odd"
−
| class=" " | Row1
+
|SUM(1,2,3)
−
| class="sshl_f" | 5
+
| 1
−
| class="sshl_f" | 2
+
| 2
−
| class="sshl_f" | 5+2i
+
| 3
−
| class="sshl_f" | 5+2j
+
| 6
 
|- class="even"
 
|- class="even"
−
| class="  " | Row2
+
| SUM(5,-9,45)
−
| class="sshl_f" |
+
| 5
−
|
+
| -9
−
|
+
| 45
−
| class=" SelectTD SelectTD" |
+
| 41
−
<div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
 
 
|- class="odd"
 
|- class="odd"
−
| Row3
+
| SUM(A1:A3)
−
| class="                                      sshl_f    " |
+
| CELL A1                       
−
|
+
| CELL A2
−
|
+
| CELL A3
−
|
+
| A1+A2+A3
 
|- class="even"
 
|- class="even"
−
| Row4
+
 
−
|
 
−
|
 
−
|
 
−
| class="  " |
 
−
|- class="odd"
 
−
| class=" " | Row5
 
−
|
 
−
|
 
−
|
 
−
|
 
−
|- class="even"
 
−
| Row6
 
−
|
 
−
|
 
−
|
 
−
|
 
 
|}
 
|}
  
−
<div align="left">[[Image:calci1.gif]]</div></div>
+
==See also==
−
----
+
 
 +
*[[Manuals/calci/AVERAGE| AVERAGE]]
 +
*[[Manuals/calci/PRODUCT| PRODUCT]]
 +
 
 +
==References==
 +
[http://en.wikipedia.org/wiki/Summation SUM]

Latest revision as of 06:56, 13 June 2014

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.
  • Sum is the operation of adding the sequence of numbers.
  • The mathematical symbol for summation is
  • 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 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
  1. It is empty cells
  2. It is logical values
  3. It is text.
  • This function shows error value when the arguments cannot be changed to numbers.

ZOS Section

  • The syntax is to calculate SUM is ZOS is
  • are numbers to be added.
  • There are any number of arguments also we can give to find the .
  • SUM(-20..-10,11..20,30..50)
Sum

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

Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/CALCI_SUM&oldid=199589"