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

Lizneth

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.

JamesB

@Lizneth

Try Using AVG instead of AVERAGE as the formula name.

=AVG([January 2023]@rpw:[October 2023]@row)

JamesB

@Lizneth

Try Using AVG instead of AVERAGE as the formula name.

=AVG([January 2023]@rpw:[October 2023]@row)

Lizneth

@JamesB Thank you so much. It worked and I can finally move on! 🤭

JamesB

Your Welcome.