writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
no edit summary
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 are first two numbers only considered.
==Examples==
#SUMBY(90,34) = 124
#SUMBY(120,-45) = 75
#SUMBY(3/4,7/8) = 1.625
==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 ]]