Average Annual Growth Rate that excludes non numeric values.

Sorry Glen, this is the formula for annual growth rates.

=SUM((L1/K1)-1+(M1/L1)-1+(N1/M1)-1+(O1/N1)-1+(P1/O1)-1+(Q1/P1)-1+(R1/Q1)-1+(S1/R1)-1+(T1/S1)-1)/9

Edit,

I think that does the same thing. I'm on a real roll today.

In fact I know it does the same thing. My calculation page is a mess. One of my N1 references was a N51. I've corected it now. Just use the first formula if you think is better.