Difference between revisions of "Manuals/calci/SUMBY"
Jump to navigation
Jump to search
(Created page with "SUMBY") |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | SUMBY | + | <div style="font-size:30px">'''SUMBY(Number1,Number2) '''</div><br/> |
| + | *<math>Number1</math> and <math>Number2</math> are any real numbers. | ||
| + | |||
| + | ==Description== | ||
| + | *This function shows the sum of the first two numbers. | ||
| + | *In <math>SUMBY(Number1,Number2)</math>,<math>Number1</math> and <math>Number2</math> are any real numbers. | ||
| + | *The mathematical symbol for summation is <math>\sum </math>. | ||
| + | *The numbers are adding together is called addends or summands. | ||
| + | *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 atleast one argument. | ||
| + | *In the arguments, the first two numbers only considered. | ||
| + | |||
| + | ==Examples== | ||
| + | #SUMBY(90,34) = 124 | ||
| + | #SUMBY(120,-45) = 75 | ||
| + | #SUMBY(3/4,7/8) = 1.625 | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|04qw5hmXojw|280|center|SUM}} | ||
| + | |||
| + | ==See Also== | ||
| + | *[[Manuals/calci/SUM| SUM]] | ||
| + | *[[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 14:45, 31 January 2019
SUMBY(Number1,Number2)
- and are any real numbers.
Description
- This function shows the sum of the first two numbers.
- In , and are any real numbers.
- The mathematical symbol for summation is .
- The numbers are adding together is called addends or summands.
- 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 atleast one argument.
- In the arguments, the first two numbers only considered.
Examples
- SUMBY(90,34) = 124
- SUMBY(120,-45) = 75
- SUMBY(3/4,7/8) = 1.625
Related Videos
See Also
References