Difference between revisions of "Manuals/calci/SUM"

From ZCubes Wiki
Jump to navigation Jump to search
 
(12 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
.
+
<div style="font-size:30px">'''SUM()'''</div><br/>
  
 +
*Parameters are  the arguments for which to find the total.
 +
**SUM(), adds its arguments
  
−
<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify">
 
  
−
The operation of adding a sequence of numbers; the result is their sum or 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 <math>\sum </math>
 +
*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 <math>+ve</math> or <math>-ve</math>.
 +
*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 at least one argument. i.e First parameter is required, and from second parameter, 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
 +
# It is empty cells
 +
# It is logical values
 +
# It is text.
 +
*This function shows error value when the arguments cannot be changed to numbers.
  
−
Sum(number1, [number2], [number3], [number4], ...)
+
==ZOS==
  
−
Will calculate total value of parameters n1, n2 etc
+
*The syntax is to calculate SUM is ZOS is <math>SUM()</math>
 +
*Parameter are numbers to be added.
 +
*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}}
  
−
Adds all the numbers in a range of cells.
+
==Examples==
−
 
 
−
</div></div>
 
−
----
 
−
<div id="6SpaceContent" class="zcontent" align="left">
 
  
 
{| id="TABLE3" class="SpreadSheet blue"
 
{| id="TABLE3" class="SpreadSheet blue"
 
|- class="even"
 
|- class="even"
−
| class="  " |
+
!Equation
−
<div id="6Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
+
| n1
−
| Column1
+
| n2
−
| class="  " | Column2
+
| n3
−
| class="  " | Column3
+
| SUM
−
| class="  " | Column4
 
 
|- class="odd"
 
|- class="odd"
−
| class=" " | Row1
+
|SUM(1,2,3)
−
| class=" " | 2
+
| 1
−
| class="sshl_f" | 3
+
| 2
−
| class="sshl_f" |
+
| 3
−
| class="sshl_f" |
+
| 6
 
|- class="even"
 
|- class="even"
−
| class="  " | Row2
+
| SUM(5,-9,45)
−
| class="sshl_f " | 8
+
| 5
−
| class="sshl_f" | 7
+
| -9
−
| class="sshl_f" |
+
| 45
−
| class="sshl_f" |
+
| 41
 
|- class="odd"
 
|- class="odd"
−
| Row3
+
| SUM(A1:A3)
−
| class="sshl_f" |
+
| CELL A1                       
−
| class="sshl_f SelectTD SelectTD" |
+
| CELL A2
−
| class="sshl_f" |
+
| CELL A3
−
| class="sshl_f" |
+
| A1+A2+A3
 
|- class="even"
 
|- class="even"
−
| Row4
+
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|- class="odd"
 
−
| class=" " | Row5
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|- class="even"
 
−
| Row6
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
 
|}
 
|}
  
−
<div align="left">[[Image:calci1.gif]]</div></div>
+
#SUM(2...10000000...6) = 4031078
−
----
+
#SUM(1..10.$(x=>x^3)) = 3025
−
</div></div></div></div></div></div></div></div></div></div></div></div>
+
#SUM((1..10)^3) = 3025
 +
#n=100;SUM((1..n)^3) = 25502500
 +
 
 +
==Related Videos==
 +
 
 +
{{#ev:youtube|04qw5hmXojw|280|center|SUM}}
 +
 
 +
==See also==
 +
 
 +
*[[Manuals/calci/AVERAGE| AVERAGE]]
 +
*[[Manuals/calci/PRODUCT| PRODUCT]]
 +
 
 +
==References==
 +
[http://en.wikipedia.org/wiki/Summation SUM]
 +
 
 +
 
 +
 
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 02:04, 30 June 2021

SUM()


  • Parameters are the arguments for which to find the total.
    • SUM(), adds its arguments


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 at least one argument. i.e First parameter is required, and from second parameter, 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

  • The syntax is to calculate SUM is ZOS is
  • Parameter 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
  1. SUM(2...10000000...6) = 4031078
  2. SUM(1..10.$(x=>x^3)) = 3025
  3. SUM((1..10)^3) = 3025
  4. n=100;SUM((1..n)^3) = 25502500

Related Videos

SUM

See also

References

SUM


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