Formula to Average Performance Score for Various Service Categories

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!