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]).

3 Commonly Utilized SharePoint Formulas

The following are three commonly used SharePoint formulas:

1. IF formula: This formula is utilized to check whether a condition is met or not. It returns one value if the condition is true and another value if the condition is false. Example: =IF([Column1]>[Column2], "Yes", "No")
2. SUM formula: This formula is utilized to add up the values in a column. Example: =SUM([Column1], [Column2], [Column3])
3. DATEDIF formula: This formula is utilized to calculate the difference between two dates in days, months, or years. Example: =DATEDIF([Column1], [Column2], "d").

3 Commonly Utilized SharePoint Formulas

The following are three commonly used SharePoint formulas:

1. IF formula: This formula is utilized to check whether a condition is met or not. It returns one value if the condition is true and another value if the condition is false. Example: =IF([Column1]>[Column2], "Yes", "No")
2. SUM formula: This formula is utilized to add up the values in a column. Example: =SUM([Column1], [Column2])
3. DATEDIF formula: This formula is utilized to calculate the difference between two dates in days, months, or years. Example: =DATEDIF([Column1], [Column2], "d")

5 Useful Sites for SharePoint Formulas

The following are five useful sites to utilize for SharePoint Formulas:

Introduction to SharePoint Formulas and Functions:

https://support.microsoft.com/en-us/office/introduction-to-sharepoint-formulas-and-functions-94e1b4cc-cd1c-49c2-80ec-90c9b9591f47  

 

Examples of Common Formulas in Lists:

https://support.microsoft.com/en-us/office/examples-of-common-formulas-in-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3

 

Use Column Formatting to Customize SharePoint:

https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting

 

Calculate Data in Lists or Libraries:

https://support.microsoft.com/en-us/office/calculate-data-in-lists-or-libraries-c5261743-667f-4833-bede-e516cef2a0e1

Understand SharePoint Forms Integration:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/sharepoint-form-integration