## Examples

`SUM(Classes[Seat Count])`

: The sum of all values in the *Seat Count* column of the *Classes* table. Equivalent to `SUM(SELECT(Classes[Seat Count], TRUE))`

. See also `SELECT()`

`SUM([Discounts])`

: The sum of the items in the `Discounts`

column value, where `Discounts`

is of type *List* or *EnumList*.

`SUM(LIST(1, 2, 3))`

returns `Number`

: `6`

### Sum Values from Select Rows

Compute the total delivery charges recorded within a reporting period:

`SUM(`

SELECT(

Deliveries[DeliveryCharge],

AND(

([DateDone] >= [_THISROW].[BeginDate]),

([DateDone] < [_THISROW].[EndDate])

)

)

)

`SELECT(Deliveries[DeliveryCharge], ...)`

gets a list of delivery charges from select rows in the`Deliveries`

table.`AND(..., ...)`

limits the`SELECT()`

results to only those rows that match all of the conditions.`([DateDone] >= [_THISROW].[BeginDate])`

limits the count to only rows with a`DateDone`

no earlier than the report's`BeginDate`

.`([DateDone] < [_THISROW].[EndDate])`

further limits the rows to those with dates before the report's end date.`SUM(...)`

totals the values from the result of the`SELECT()`

.

### Common Problems

`SUM(1, 2, 3)`

: the arguments are not in list form. To fix, wrap them in `LIST()`

to construct a list: `SUM(LIST(1, 2, 3))`

.

## Syntax

**SUM(** *some-list* **)**

## Arguments

`some-list`

(list of any numeric type)

AppSheet must be given enough context to determine what type of values `some-list`

contains, that its contents are or will be numeric. To that end, `some-list`

must be one of the following: a column value of type `List`

that contains numeric values; a column list (e.g., `Products[Price]`

) for a column of a numeric type; or a constructed list (e.g., with `LIST()`

) of a numeric type.

## Return Value

The computed sum of the values in `some-list`

.