Difference between revisions of "Manuals/calci/sum1"
Jump to navigation
Jump to search
| (2 intermediate revisions by the same user not shown) | |||
| Line 5: | Line 5: | ||
'''SUM ('''r1,r2,ext r1....) | '''SUM ('''r1,r2,ext r1....) | ||
| − | where | + | where :- |
'''n1,n2.......''' - represents the number which to be add. | '''n1,n2.......''' - represents the number which to be add. | ||
| Line 25: | Line 25: | ||
SUM ignore the values that cannot be converted into numbers. | SUM ignore the values that cannot be converted into numbers. | ||
| − | If an parameter is an array or refernece,only | + | If an parameter is an array or refernece,only numbers in that are counted (see example 2). |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
---- | ---- | ||
<div id="8SpaceContent" class="zcontent" align="left"> | <div id="8SpaceContent" class="zcontent" align="left"> | ||
| Line 43: | Line 38: | ||
Consider another example | Consider another example | ||
| − | <nowiki>=SUM("3",4,TRUE)</nowiki> | + | <nowiki>=SUM("3",4 ,TRUE)</nowiki> |
SUM of 3, 4 and TRUE is (8). | SUM of 3, 4 and TRUE is (8). | ||
Latest revision as of 11:23, 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).
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 |