Difference between revisions of "Manuals/calci/SUM"

From ZCubes Wiki
Jump to navigation Jump to search
 
(18 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">
 
−
Sum(number1, [number2], [number3], [number4], ...)
 
  
 +
==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.
  
−
The operation of adding a sequence of numbers; the result is their sum or total
+
==ZOS==
  
−
</div></div>
+
*The syntax is to calculate SUM is ZOS is <math>SUM()</math>
−
----
+
*Parameter are numbers to be added.
−
<div id="4SpaceContent" align="left"><div class="ZEditBox" align="justify">
+
*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==
  
−
</div></div>
+
{| id="TABLE3" class="SpreadSheet blue"
−
 
+
|- class="even"
−
----
+
!Equation
−
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman"> <font size="6">SUM</font> </font>'''</div></div>
+
| n1
 +
| n2
 +
| n3
 +
| SUM
 +
|- class="odd"
 +
|SUM(1,2,3)
 +
| 1
 +
| 2
 +
| 3
 +
| 6
 +
|- class="even"
 +
| SUM(5,-9,45)
 +
| 5
 +
| -9
 +
| 45
 +
| 41
 +
|- class="odd"
 +
| SUM(A1:A3)
 +
| CELL A1                       
 +
| CELL A2
 +
| CELL A3
 +
| A1+A2+A3
 +
|- class="even"
  
 +
|}
  
−
----
+
#SUM(2...10000000...6) = 4031078
−
<div id="3SpaceContent" class="zcontent" align="left"><br /><div id="7Space" class="gamizbox" title="7Space"><div id="7SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="7SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="7SpaceRollupContent" align="center"></span></span></div><div id="7SpaceCover"><div id="7SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="3" face="Times New Roman"> </font>'''SUM'''(n1,n2, ...)
+
#SUM(1..10.$(x=>x^3)) = 3025
 +
#SUM((1..10)^3) = 3025
 +
#n=100;SUM((1..n)^3) = 25502500
  
−
Will calculate total value of  parameters n1, n2 etc
+
==Related Videos==
  
−
</div></div>
+
{{#ev:youtube|04qw5hmXojw|280|center|SUM}}
−
----
 
−
<div id="14SpaceContent" class="zcontent" align="left"><br /><br /><br /><div id="5Space" class="gamizbox" title="5Space"><div id="5SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="5SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="5SpaceRollupContent" align="center"></span></span></div><div id="5SpaceCover"><div id="5SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">
 
  
−
Adds all the numbers in a range of cells.
+
==See also==
  
−
</div></div>
+
*[[Manuals/calci/AVERAGE| AVERAGE]]
 +
*[[Manuals/calci/PRODUCT| PRODUCT]]
  
−
----
+
==References==
−
<div id="12SpaceContent" class="zcontent" align="left"><br /><br /><br /><div id="9Space" class="gamizbox" title="9Space"><div id="9SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="9SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="9SpaceRollupContent" align="center"></span></span></div><div id="9SpaceCover"><div id="9SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="2"><font color="#484848"><font face="Arial">=SUM(2,4)  = 6</font></font></font>
+
[http://en.wikipedia.org/wiki/Summation SUM]
  
−
=SUM(2,”4”,TRUE) = 6
 
  
−
</div></div>
 
−
----
 
−
<div id="6SpaceContent" class="zcontent" align="left">
 
  
−
{| id="TABLE3" class="SpreadSheet blue"
+
*[[Z_API_Functions | List of Main Z Functions]]
−
|- class="even"
 
−
| class="  " |
 
−
<div id="6Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
 
−
| Column1
 
−
| class="  " | Column2
 
−
| class="  " | Column3
 
−
| class="  " | Column4
 
−
|- class="odd"
 
−
| class=" " | Row1
 
−
| class=" " | 2
 
−
| class="sshl_f" | 3
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|- class="even"
 
−
| class="  " | Row2
 
−
| class="sshl_f " | 8
 
−
| class="sshl_f" | 7
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|- class="odd"
 
−
| Row3
 
−
| class="sshl_f" |
 
−
| class="sshl_f SelectTD SelectTD" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|- 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>
+
*[[ Z3 |  Z3 home ]]
−
----
 
−
</div></div></div></div></div></div></div></div></div></div></div></div>
 

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"