Footer formula

Available footer formula

Formula name	Usage
Count all	Counts and displays the number of cells in a column.
Count empty	Counts and displays the number of empty cells in a column.
Count not empty	Counts and displays the number of cells with a value in a column.
Count distinct	Counts and displays the number of unique values in a column.
Sum	Displays the sum of the values in that column.
Average	Displays the average value of the column.
Maximum	Displays the highest value in a column.
Minimum	Displays the lowest value in a column.

If the selected column is not a Number type, it won't have the Sum, Average, Maximum, Minimum, and Formula options.