Hi all -
I am attempting to collect the average of a column of scores IF criteria is met in a separate column. For example:
In the image below, I want to get the average of the Flexibility Score Column IF the Project - Client Name column has a specific name.
I tried the suggestions in previous posts but continue to get #UNPARSABLE or #INVALID
Help Article Resources
Check out the Formula Handbook template!