Formulas for Table Columns

You may want to reduce the number of columns to a given value.

Get a Table column

To select a table column, just type the table name on a calculation, folowed by a . and the column name.

On this example, we are selecting the column Amount from the table Expenses.

count()

You may simply want to count number of entries on a list or column:

countif()

You may simply want to count the number of entries that respect a certain condition:

sum() / total()

You may want to sum up an entire column:

total is the name of the function that does exactly the same as sum, so you can use that instead.

sumif()

You may want to sum up an entire column only for the elements that respect a certain condition: