Formula to Average Performance Score for Various Service Categories

Options
ullkay95
ullkay95 ✭✭
edited 07/31/23 in Formulas and Functions

I am trying to create a formula that averages the performance score of various service categories.

For example, whenever the service category (drop down box) has "civil engineer" selected, I want a running formula that averages all the civil engineer ratings. I have tried using the =averageif() formula, but I continue to get an error.


I would like the formula to be on the bottom row:


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!