# 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.                            |

{% hint style="info" %}
If the selected column is not a Number type, it won't have the Sum, Average, Maximum, Minimum, and Formula options.
{% endhint %}
