Can you explain to me the difference between what you originally said ...

I was wondering is there a formula to calculate the "average annual growth rate" of the most recent 10 numbers out of the total 20 cells, that excludes any non numeric values.

and what you say my formula gives ...

I now know what your formula does. It's giving me the average of a maximum 10 of the most recent figures.

That seems the same to me.