Difference between revisions of "Manuals/calci/SUMBY"
Jump to navigation
Jump to search
(One intermediate revision by the same user not shown) | |||
Line 10: | Line 10: | ||
*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 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. | *We must give atleast one argument. | ||
− | *In the arguments | + | *In the arguments, the first two numbers only considered. |
==Examples== | ==Examples== | ||
Line 16: | Line 16: | ||
#SUMBY(120,-45) = 75 | #SUMBY(120,-45) = 75 | ||
#SUMBY(3/4,7/8) = 1.625 | #SUMBY(3/4,7/8) = 1.625 | ||
+ | |||
+ | ==Related Videos== | ||
+ | |||
+ | {{#ev:youtube|04qw5hmXojw|280|center|SUM}} | ||
==See Also== | ==See Also== |
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