Difference between revisions of "Manuals/calci/SUMBY"
Jump to navigation
Jump to search
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== |
Revision as of 13:56, 22 May 2017
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
See Also
References