Averages and Counts
I'm trying to obtain the average percentage of completion of the goal progress for all the goals associated with a specific team member.
Please help! :)
This is the formula I'm using:
=AVERAGEIF([PROJECT TEAM]:[PROJECT TEAM], [GOAL PROGRESS]:[GOAL PROGRESS], FIND("Ed Brandt", @cell) > 0)
Help Article Resources
Check out the Formula Handbook template!