Manuals/calci/SUMBY

From ZCubes Wiki
Revision as of 14:45, 31 January 2019 by Devika (talk | contribs) (→‎Examples)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
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