Difference between revisions of "Manuals/calci/SUMBY"

From ZCubes Wiki
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

  1. SUMBY(90,34) = 124
  2. SUMBY(120,-45) = 75
  3. SUMBY(3/4,7/8) = 1.625

Related Videos

SUM

See Also

References