Calculating an average confidence level

earl_bennett ✭✭✭✭✭
edited 05/16/22 in Formulas and Functions

I'm creating a metrics sheet that collects the confidence level ( 1 through 10 ) by month. What I'm trying to figure out is how to calculate or identify the average confidence level received.

The diagram below shows that I have entries for confidence levels 7,8, and 10. How do I determine the teams confidence level is say... 8.5?

Thanks so much...

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!