## 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*.

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