According to this site, you can use AVERAGE as an array function:
https://www.exceltip.com/st/Calculat...owth/1096.html

Dave
--
Brevity is the soul of wit.


"Scott" wrote:

Dave F,

Thanks for your response. That does what I am looking for, although I was
looking for a formula that I could fit in one cell to accomplish it. Sorry
for not being more specific.

Thanks!

"Dave F" wrote:

Here's something more specific

1 $10,000,000.00
2 $14,740,634.86 47.41%
3 $16,736,647.04 13.54%
4 $16,922,847.13 1.11%
5 $18,653,648.44 10.23%
6 $26,127,105.88 40.06%
7 $33,074,355.97 26.59%
8 $42,284,677.94 27.85%
9 $42,545,480.92 0.62%
10 $49,387,299.55 16.08%

20.39%

Range is A1:c12.

C2 = B2/B1-1 etc, filled down to C10

C12 = AVERAGE(C2:C10) = 20.39% average growth rate.

Is that what you're looking for?

Dave

--
Brevity is the soul of wit.


"Dave F" wrote:

Calculate the revenue growth rate for each pair of consecutive years and then
average those rates.
--
Brevity is the soul of wit.


"Scott" wrote:

If I have a revenue number for 10 concescutive years, what is the best way to
get the average growth rate for these numbers? Thanks!