Sorry I'm new to SharePoint. I am building a tool to track projects and would just like to ask if it is possible to have a column to automatically average all projects with the same 'priority name' and 'quarter' (e.g. Q1, Q2, Q3..) that it belongs to.

The value at which these figures will be calculated will be coming from one column to be populated manually - 'project rating'.

Thank you in advance and more power!


2 Answers 2


There is a formula called AVERAGEA function, you can use it.

Have a try and let's know the result.


Short answer to your question is No.

AVERAGEIFS is not available in SharePoint calculated column formulas.

However, AVERAGE and AVERAGEA functions are available.

AVERAGE function:

Returns the average (arithmetic mean) of the arguments.

AVERAGEA function:

Calculates the average (arithmetic mean) of the values in the list of arguments. Unlike the AVERAGE functions, text and logical values such as TRUE and FALSE are included in the calculation.

Check all common formulas available in SharePoint Lists:

Examples of common formulas in SharePoint Lists.

Also, you can show Average of a list column in SharePoint list view by settings Totals in View settings.

You can add some filters in list view based on project, priority name and maybe some date fields and show the average of column in list view.

Check this if it helps you: Creating List Views - Specify Totals for a View.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.