The following are the top five SharePoint mathematical functions to use in calculated columns, functions and views:
- SUM: Used to sum all the numbers in a column.
- AVERAGE: Used to calculate the average of all the numbers in a column.
- MAX: Used to return the highest value in a column.
- MIN: Used to return to the lowest value in a column.
- COUNT: Used to count the number of items in a column.
