- 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. See Examples below.
The computed sum of the values in some-list.
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(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)).
SUM(LIST()) : the constructed list has no items from which to determine type.