average formula is not working to calculate total retention and total turnover


First row is retention rate and second row is turnover and it keeps giving me an error. Below is the formula i am using for average

this is the formula i used to get turnover percentage:

But every time I put the average I get an error. Can somebody please help.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!