Skip to main content

Formulas for table columns

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

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: