AVG(IF) statement based on criteria
Hi Team, Can you please help me write a formulae wherein each KPI has 4 options in dropdown value each representing a certain value as below
Partially Met = 100%, Met = 100%, Not Met = 0%
How do bring an average value under Score based on the selection in the three KPI. I have entered the Score %s for your reference so the formulae output can match the same.
Can you please help.
Help Article Resources
Check out the Formula Handbook template!