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)
Thank you!!
Wendy
Answers
-
Hi Wendy,
The structure of an AVERAGEIF is as follows: Range with Criteria, then the Criteria, then finally the Range to Average. These would be the different elements, for your sheet:
Range with Criteria: [PROJECT TEAM]:[PROJECT TEAM]
Criteria: HAS(@cell, "Contact Name")
Range to AVG: [GOAL PROGRESS]:[GOAL PROGRESS]
With that in mind, try this full formula:
=AVERAGEIF([PROJECT TEAM]:[PROJECT TEAM], HAS(@cell, "Contact Name"), [GOAL PROGRESS]:[GOAL PROGRESS])
I used HAS because it was built specifically for multi-select drop-down columns, for contact lists or regular lists. Let me know if this works for you, or if you have any questions!
Cheers,
Genevieve
Help Article Resources
Categories
Check out the Formula Handbook template!