Top 4 Average Formulas in SharePoint

The following are the top four average formulas in SharePoint:

1. Average of two columns: To calculate the average of two columns, use the following formula: =[Column1]+[Column2])/2.
2. Average of multiple columns: To calculate the average of multiple columns, use the following formula: =AVERAGE([Column1], [Column2], [Column3]).
3. Average of selected items: To calculate the average of selected items in a choice column, use the following formula: =AVERAGE([Choices]).
4. Average of a column with errors: To calculate the average of a column with errors, use the following formula: =IF(ISERROR([Column1]/[Column2]), "-", [Column1]/[Column2]).