Difference between revisions of "Manuals/calci/SUMBY"

From ZCubes Wiki
Jump to navigation Jump to search
 
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 15: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