SUM

Returns the sum of all numbers in the provided arguments

Syntax

SUM(number1, [number_n])

Arguments

Argument Description Required
number1 The first number or range to calculate sum Required
number_n Additional numbers or ranges to calculate sum Optional

Examples

Sum individual numbers

=SUM(1, 2, 3)

Result ⇒ 6

Sum values in a range

=SUM(A1:A3)

Result ⇒ 60
A
1 10
2 20
3 30

Sum mixed numbers and ranges

=SUM(A1:A2, 10, 20)

Result ⇒ 50
A
1 5
2 15

Related Functions

Other Math functions:

  • ABS - Returns the absolute value of a number
  • ACOS - Returns the arccosine, or inverse cosine, of a number
  • ASIN - Returns the arcsine, or inverse sine, of a number
  • ATAN - Returns the arctangent, or inverse tangent, of a number
  • CEILING - Rounds a number up to the nearest integer or to the nearest multiple of significance
  • COS - Returns the cosine of the given angle
  • EXP - Returns e raised to the power of a given number
  • FACT - Returns the factorial of a number
  • FLOOR - Rounds a number down to the nearest multiple of significance
  • INT - Rounds a number down to the nearest integer
  • LN - Returns the natural logarithm of a number
  • LOG - Returns the logarithm of a number to a specified base
  • LOG10 - Returns the base-10 logarithm of a number
  • MOD - Returns the remainder after a number is divided by a divisor
  • PI - Returns the value of pi (π)
  • POWER - Returns the result of a number raised to a power
  • RAND - Returns a random number greater than or equal to 0 and less than 1.
  • ROUND - Returns the number after rounding it to a certain number of decimal places.
  • ROUNDDOWN - Returns a number rounded to a certain number of decimal places. ROUNDDOWN rounds all numbers down.
  • ROUNDUP - Returns a number rounded up to a certain number of decimal places. ROUNDUP rounds all numbers up.
  • SIGN - Determines the sign of a number
  • SIN - Returns the sine of the given angle
  • SQRT - Returns the square root of a number
  • TAN - Returns the tangent of the given angle
  • TRUNC - Truncates a number to an integer by removing the fractional part