Skip to main content

Formulas for Lists of Numbers

max()​

This formula gives you the maximum value of a list or table column:

min()​

This formula gives you the minimum value of a list or table column:

sum() / total()​

This formula gives you the sum of all numbers in a list or a table column:

average() / mean() / avg()​

This formula gives you the mean of a list of numbers:

averageif() / meanif() / avgif()​

This formula gives you the mean of a list of numbers that respect a certain condition:

grow()​

This formula compounds an initial value by a specific rate over any sequence or list of values.

stepgrowth()​

This formula gives you the increments (or decrements) between values in a sequence or list.

abs()​

Can calculate all the absolute numbers of the numbers contained in a list: