Difference between revisions of "Manuals/calci/sum1"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''SUM'''(n1,n2,n3.........) '''SUM ('''r1,r2,ext r1.... ............) where, '''n1,n2.......''' - repres...")
 
Line 3: Line 3:
 
'''SUM'''(n1,n2,n3.........)
 
'''SUM'''(n1,n2,n3.........)
  
'''SUM ('''r1,r2,ext r1....
+
'''SUM ('''r1,r2,ext r1....)
 
 
............)
 
  
 
where,
 
where,
Line 23: Line 21:
 
<div id="7SpaceContent" class="zcontent" align="left">
 
<div id="7SpaceContent" class="zcontent" align="left">
  
Numbers, logical values, array or references that represents numbers, directly pass
+
Numbers, logical values, array or references that represents numbers, directly pass into parameters are counted .
 
 
into parameters ate counted .
 
  
 
SUM ignore the values that cannot be converted into numbers.
 
SUM ignore the values that cannot be converted into numbers.
Line 92: Line 88:
 
| class=" " | -12
 
| class=" " | -12
 
| class="sshl_f SelectTD  SelectTD ChangeBGColor" |
 
| class="sshl_f SelectTD  SelectTD ChangeBGColor" |
<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]]</div>12
+
<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">
 
|
 
|
 
|
 
|
Line 115: Line 111:
 
|}
 
|}
  
<div align="left">[[Image:calci1.gif]]</div></div>
+
<div align="left">
----
 

Revision as of 11:17, 18 November 2013

SUM(n1,n2,n3.........)

SUM (r1,r2,ext r1....)

where,

n1,n2....... - represents the number which to be add.

There is no limit to how many parameters pass to SUM.


Calci adds all numbers from set of array.


Numbers, logical values, array or references that represents numbers, directly pass into parameters are counted .

SUM ignore the values that cannot be converted into numbers.

If an parameter is an array or refernece,only

numbers in that are counted(see example 2).


SUM

Lets see an example in (Column2,Row1)

=SUM(C1R2,C1R3)

SUM of C1R2 and C1R3 (-5).

Consider another example

=SUM("3",4,TRUE)

SUM of 3, 4 and TRUE is (8).

Let see an in example2 in (C2R3)

=SUM(C1R2:C1R6)

Calci adds only numbers (12).


Syntax

Remarks

Examples

Description

Column1 Column2 Column3 Column4
Row1 SMITH -5
Row2 7 8
Row3 -12
Row4 17
Row5 FALSE
Row6 -10