AVERAGEIF Formula Help
I'm trying to come up with a summary sheet formula that summarizes an employee's average evaluation score. I'm working with two columns: Employee Name and Overall Satisfaction.
Let's say their name is Slim Jones. The formula I came up with is:
=AVERAGEIF(Employee Name:Employee Name, "Slim Jones", [Overall Satisfaction]:[Overall Satisfaction])
But I keep getting the message UNPARESABLE. What am I doing wrong? It seems pretty straightforward.
Help Article Resources
Check out the Formula Handbook template!