Returns the sum of a series of numbers and/or cells.
SUM for BigQuery
Returns the sum of a data column.
Sample Usage
=SUM(table_name!inventory)
Syntax
SUM(column)
column
- The data column to consider when calculating the sum.
Tip: Returning sum across multiple columns is not supported.
Sample Usage
SUM(A2:A100)
SUM(1,2,3,4,5)
SUM(1,2,A2:A50)
Syntax
SUM(value1, [value2, ...])
value1
- The first number or range to add together.value2, ...
- [ OPTIONAL ] - Additional numbers or ranges to add tovalue1
.
Notes
- If only a single number for
value1
is supplied,SUM
returnsvalue1
. - Although
SUM
is specified as taking a maximum of 30 arguments, Google Sheets supports an arbitrary number of arguments for this function.
See Also
SUMSQ: Returns the sum of the squares of a series of numbers and/or cells.
SUMIF: Returns a conditional sum across a range.
SERIESSUM: Given parameters x
, n
, m
, and a
, returns the power series sum a1xn + a2x(n+m) + … + aix(n+(i-1)m), where i is the number of entries in range a
.
QUOTIENT: Returns one number divided by another, without the remainder.
PRODUCT: Returns the result of multiplying a series of numbers together.
MULTIPLY: Returns the product of two numbers. Equivalent to the \*
operator.
MINUS: Returns the difference of two numbers. Equivalent to the -
operator.
DIVIDE: Returns one number divided by another. Equivalent to the /
operator.
ADD: Returns the sum of two numbers. Equivalent to the +
operator.