Difference between revisions of "Manuals/calci/SUM"
Jump to navigation
Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="4SpaceContent" align="left"><div class="ZEditBox" align=...") |
|||
| (23 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''SUM()'''</div><br/> |
| − | + | *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 <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. | ||
| − | + | ==ZOS== | |
| − | |||
| − | |||
| − | + | *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}} | ||
| − | + | ==Examples== | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | {| id="TABLE3" class="SpreadSheet blue" | |
| + | |- class="even" | ||
| + | !Equation | ||
| + | | 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 | |
| + | #SUM(1..10.$(x=>x^3)) = 3025 | ||
| + | #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
or 
.- 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
- 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)
.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 |
- SUM(2...10000000...6) = 4031078
- SUM(1..10.$(x=>x^3)) = 3025
- SUM((1..10)^3) = 3025
- n=100;SUM((1..n)^3) = 25502500
Related Videos
See also
References