Calculate Growth rate in Excel

Question

I have a last year sale and some currant year sale so I want calculate growth rate in F3 Cell number and I have used this formula =SUM(D3:D4)/SUM(C3:C4)-1 to calculate the growth rate.

Something like this:

If I add some Sale in Current year then I drag down sum formula range in growth rate formula:

I want automatic Calculate growth rate if I add new value in Current year and then automatic collect Sale from last year in same currant year sale and calculate growth rate.

Note: Growth rate will be Calculate day by day...

Answer 1

In order to get the Average Annual Growth Rate in Excel, we must first calculate the annual growth rates for each year using the formula = (Ending Value - Beginning Value) / Beginning Value, and then average them.

Besides the original table, enter the below formula into the blank Cell C3 and, and then drag the Fill Handle to the Range C3:C11.

=(C4-C3)/C3

2. On the Home tab, select the Range D4:D12, then click the Percent Style button to adjust the decimal places by clicking the Increase Decimal or Decrease Decimal buttons.

3. Enter the formula below into Cell F4 and click the Enter key to average all annual growth rates.

=AVERAGE(D4:D12)