# SUM

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 to `value1`.

### Notes

• If only a single number for `value1` is supplied, `SUM` returns `value1`.

• Although `SUM` is specified as taking a maximum of 30 arguments, Google Sheets supports an arbitrary number of arguments for this function.

`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.

Search
Clear search
Close search