Average annual growth rate excluding non numeric values.

[p45cal]

Sometimes there's no figures for a year and I have to go with the year before.

That's the bit I disagree with.