How to get an "Average" of statuses
I am trying to find the best formula to get an average of statuses. I have a helper sheet build out for this purpose. I have certain sub-goals and several projects tied to these sub-goals, each of the projects has a status - not started, in progress and complete. I am trying to find a formula where out of these projects that fall under the same sub-goal category, I want the average status. Let's say I have 4 Not Started, 1 in Progress and 2 Complete - I want to know what's my average out of these. Which formula would be best to use in this case? I tried Averageif but it doesn't seem to be working. Any ideas are very appreciated!
Help Article Resources
Check out the Formula Handbook template!