Average Growth Rate in Excel: Calculate It Step by Step

How-to basics · Updated November 18, 2026

To calculate the arithmetic average of period-by-period growth rates in Excel, calculate each rate in a helper column, then average those results with =AVERAGE(C3:C6). If you want the single constant rate that connects the first and last values, calculate CAGR instead. You will need a chronological series of numeric values and should choose the measure that matches your question before interpreting the result.

What You’ll Need

  • Microsoft Excel for Microsoft 365 on Windows. The formulas also work in Excel for Mac and Excel for the web, though ribbon layout can vary.
  • A series of values in time order, such as annual revenue, monthly subscribers, or quarterly production. Include a date or period label for each value if you have one.
  • A decision about whether you need the arithmetic average of observed rates or the compound annual growth rate (CAGR). They answer different questions.

Step-by-Step

  1. Arrange and check the data. Put dates or period labels in column A and the corresponding measurements in column B. For example, enter years 2020 through 2024 in A2:A6 and values 100, 120, 108, 135, and 150 in B2:B6. Keep the oldest period at the top and the newest at the bottom. Make sure the values are numeric, not numbers stored as text, and do not include a heading in the calculation range. The example uses simplified units; the same method applies to dollars, users, units sold, or another measure.
  2. Choose what average growth means for your report. The arithmetic average answers, “What was the average of the growth rates from one period to the next?” It gives each period’s percentage change equal weight. CAGR answers, “What steady annual rate would take the starting value to the ending value over this time?” It accounts for compounding and depends on the endpoints and elapsed periods. If someone asks simply for an average of the observed annual changes, use the arithmetic average; if they want a comparable rate from start to finish, use CAGR.
  3. Calculate each period’s growth rate. With the example dates in A2:A6 and values in B2:B6, enter a heading such as Growth rate in C2. With the prior period’s value in B2 and the current period’s value in B3, enter this in C3: =B3/B2-1. Press Enter, select C3, and drag the fill handle down through C6. Excel adjusts the references for each row, comparing every value with the one immediately before it. For example, the first calculation is 120 divided by 100, minus 1, or 20%; the next is 108 divided by 120, minus 1, or -10%.
  4. Average the observed rates. With the four period-to-period growth rates in C3:C6, enter =AVERAGE(C3:C6) in an empty cell such as C8. The example returns about 11.53%. The four rates are 20%, -10%, 25%, and about 11.11%; their sum divided by four is about 11.53%. A negative period is included as a real result, not discarded. Format C8 as a percentage so the result is easy to read.
  5. Calculate CAGR when you need a compounded rate. With five annual observations in B2:B6, starting value B2 equal to 100, and ending value B6 equal to 150, enter =(B6/B2)^(1/(COUNT(B2:B6)-1))-1 in an empty cell. The formula divides the ending value by the starting value, raises that ratio to the reciprocal of the four intervals between five observations, then subtracts 1. It returns about 10.67% per year. There are four intervals, not five: 2020 to 2021 is one interval and 2023 to 2024 is the fourth. This result differs from 11.53% because CAGR compounds a constant rate across the whole span, whereas the arithmetic average simply averages the four individual rates.
  6. Format and label the result. Select the result cell, then choose Home > Number > Percent Style. Use the increase or decrease decimal buttons in the Number group to show an appropriate level of precision. Label the result clearly, for example Average annual growth rate (arithmetic) or CAGR, rather than leaving a bare percentage. A value stored as 0.1067 will display as 10.67% with percentage formatting; formatting changes how Excel displays the value, not the underlying calculation.
  7. Adjust for uneven or monthly periods when needed. The basic CAGR formula assumes the observations are equally spaced. If dates in A2:A6 are irregular, with the first and last dates in A2 and A6 and their values in B2 and B6, use =(B6/B2)^(365.25/(A6-A2))-1 for an approximate annualized rate based on actual elapsed days. The date cells must contain real Excel dates, and the values must be positive. For regular monthly observations, the per-period arithmetic average is still an average monthly rate. If you want an effective annualized CAGR from monthly values in B2:B6, use =(B6/B2)^(12/(COUNT(B2:B6)-1))-1. With five monthly observations, there are four monthly intervals, so this annualizes the four-interval change; use a longer series when you intend to report a full-year trend.

In Excel for Mac and Excel for the web, enter the same formulas in cells and fill them down as described. The ribbon’s placement may look different, but the calculation does not change. In localized Excel installations, function names or list separators can depend on language and regional settings; use the syntax your installation expects if it rejects a formula pasted from this guide.

Common Mistakes

  • Mixing up arithmetic average and CAGR. The arithmetic average summarizes the individual period rates. CAGR describes a constant compounded rate between endpoints. They are not interchangeable, and a volatile series can make the difference noticeable.
  • Counting observations instead of intervals. Five yearly values span four years. The CAGR exponent must use the number of elapsed intervals, which is one fewer than the number of equally spaced observations.
  • Reversing the order of the values. Growth is usually calculated as current value divided by prior value, minus one. Reversing that order gives a different result and does not measure the same change.
  • Including the heading or the starting row in the average. In the example, the first rate is in C3 because there is no earlier value for B2. Average C3:C6, not C2:C6, and do not include a label or a manually entered total.
  • Using percentage formatting as if it calculated a percentage. A raw result of 0.2 is equivalent to 20%. Applying Percentage format displays it as 20%; multiplying by 100 in the formula and then formatting it as a percentage would display 2,000%.
  • Ignoring zeros, negative values, or gaps. A zero starting value makes a percentage increase undefined because division by zero is not possible. Negative values can also make percentage growth misleading, and CAGR may not be a real number for a negative endpoint ratio raised to a fractional power. Do not silently remove these observations; choose a measure that makes sense for the underlying data.

Tips

  • Keep the original measurements in one column and calculated rates in another. This makes the comparison between period values visible and makes errors easier to trace.
  • Use consistent periods. Do not treat a six-month gap and a one-year gap as if they were equal annual intervals. Add dates or normalize the rate when periods differ.
  • Show the time span beside the result, such as 2020–2024 CAGR. A rate without its period and method can be misunderstood.
  • Retain enough decimal places in the stored calculation and round only for display or final reporting. A displayed 10.7% can still use the full underlying value in later formulas.
  • Check the result against the data. If every value is positive and the series ends above where it began, CAGR should be positive. If the series ends below its starting point, CAGR should be negative.
  • If the series is very volatile, report both the arithmetic average and CAGR when useful, and label each. The arithmetic mean describes typical observed period change; CAGR summarizes the compounded outcome.

Troubleshooting

  • The formula shows #DIV/0!. Check whether the prior-period value in column B is zero or blank. A percentage change from zero has no defined denominator. Confirm the source data and decide whether a different measure, such as absolute change, is more meaningful for that interval.
  • The formula shows #VALUE! or does not calculate. Look for values imported as text, stray spaces, or labels inside the numeric range. Select a problem cell and check whether Excel recognizes it as a number. Also check that parentheses and minus signs were copied correctly. If your regional settings use semicolons rather than commas, this guide’s AVERAGE formula has only one argument, but formulas with multiple arguments may need your local separator.
  • The result is much too large or too small. Confirm that the value in column B is stored as 20 rather than 20% if it means twenty units, and ensure the rate is not multiplied by 100 before percentage formatting. Verify the oldest and newest rows are in the expected order and check the formula references after filling down.
  • CAGR returns an error or an unexpected result. Check that the beginning and ending values are positive and that the number of numeric observations is correct. Blank cells reduce COUNT, so a gap can change the interval count and make the exponent wrong. For missing periods, establish the actual elapsed time instead of assuming every observation is consecutive and evenly spaced.
  • The growth rates appear as decimals. This is normal if the cells have General format. Select the rate cells and choose Home > Number > Percent Style. If the value is -0.1, Excel will display -10% once percentage formatting is applied.

Frequently Asked Questions

What is the formula for average growth rate in Excel?
For an arithmetic average, calculate each period’s rate as current value divided by prior value, minus one, then use AVERAGE on the rate cells. With rates already in C3:C6, the average formula is =AVERAGE(C3:C6). Use CAGR instead when the question is about the compounded rate from the first observation to the last.

Can I calculate average growth without a helper column?
Yes, for CAGR you can use the start and end values and the interval count in one formula. For the arithmetic average, a helper column is usually easier to audit because it exposes each period’s percentage change. It also makes it simpler to spot a zero, missing value, or unusually large change.

Should I use average growth rate or CAGR?
Use the arithmetic average to summarize the average of observed period-by-period rates. Use CAGR to express the compounded rate that connects the start and end values. If a report does not specify which one it means, state the method in your label or ask the reader which measure is required.

How do I calculate average monthly growth in Excel?
Calculate each month’s change against the previous month and average those monthly rates. The result is an average per month, not an annual rate. If you need a compounded annualized figure, use the monthly CAGR approach and make sure the observations are consistently spaced and cover the intended time span.

Can average growth be negative?
Yes. If declines outweigh increases, the arithmetic average can be negative. CAGR can also be negative when the ending value is below a positive starting value. A negative result indicates contraction over the measured periods; check that the data order and units are correct before interpreting it.

What if my values include zero or negative numbers?
Percentage growth and CAGR may not be appropriate when values cross or include zero, especially because division by zero is undefined and fractional powers of negative ratios may not produce real results. Consider reporting absolute change, such as units gained or lost, or consult the definition required for your specific metric.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.