Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

How to Calculate a Rolling Average in Excel

While analyzing data in Excel, you might need to calculate averages of different subsets of a specified data range to get the variations or fluctuations in the data. If you want to forecast the trend in data, this is referred to as a moving average, rolling average, running average, or moving mean.

Finding the Rolling Average in Excel 

This technique is used to analyze the trend in data for a certain interval of time or period. It is frequently used to get the trends in sales data, economic data, statistical data, weather temperatures, and stock prices to show the average value of data set over a given period of time. For example, you need to calculate the moving average of sales data for the last 3 months to get the trend in sales data.

In this article, you will learn how to calculate moving average or rolling average in Excel. In Excel, there are various methods to calculate moving average or rolling average which will be discussed here.

Suppose you have business sales data of 12 months and you want to see the trend in sales by calculating a moving average or rolling average over a period of the last 3 months. You can calculate the moving average by using the following methods in Excel.

Using the AVERAGE function in Excel

Using the Average function, you can easily calculate a series of averages or a moving average of the required interval of time/period of a given data range of 12 months sales. As you need to get the series moving averages of the last 3 months, therefore you need to enter the cell references of first three cells in the AVERAGE function in the third adjacent cell of monthly sales data, like in cell C4, and drag or copy it down, as shown below.


In column C, you get a series of averages for a period of last 3 months, and that is referred to as moving the average or rolling average of last 3 months sales data.

Using Analysis ToolPak Add-in for Moving Average in Excel

In Excel, Analysis ToolPak add-in has a built-in option to calculate moving average for the range of data. For this purpose, you need to first install this add-in from available add-ins in Excel Options dialog box.

After installing Analysis ToolPak add-in, you need to go back to the main Excel interface, click on the Data tab and click on Data Analysis button in Analysis section.

A Data Analysis dialog box appears, click on Moving Average option from Analysis Tools and click on OK.

Now, Moving Analysis dialog box appears to make calculations. You need to do followings in this dialog box;

  • First, put a cursor in the Input Range section and select the range of sales data B2:B13.
  • Second, go to Interval section and insert 3 as an interval period.
  • Third, insert the data range to show the result of the moving average in the Output Range section as C2:C13.
  • Fourth, you can select Chart Output checkbox optionally to generate chart as well showing a trend of sales.
  • Finally, press OK button to calculate the moving average of sales data for the last 3 months.

You will get a series of moving averages in output cells range, and a Moving Average chart will also be created, showing actual and forecast trend based on the last 3 months sales figures.

Adding Moving Average Trendline in an Excel Chart

You can show Moving Average Trendline in an existing chart in Excel by supplying interval as 3 months in our example here. First, you need to insert a Column Chart for 12 months sales figures in Excel, and then you need to add Moving Average Trendline in that chart.

First, insert a column Chart for the selected range of data below.

Click anywhere in chart area, in Chart Tools, go to Layout tab, click on the drop-down button of Trendline button in Analysis section and then click on More Trendline Options.

A Format Trendline dialog box appears. In Trendline Options, select Moving Average and enter 3 as period and click the Close button.

A Moving Average Trendline is added in the created chart showing the monthly sales performance in Excel. This approach is good where you do not need to calculate and show moving average figures, but you only need to show the trend of a sales forecast based on the moving average over a certain period.

Still need some help with Excel formatting or have other questions about Excel? Connect with a live Excel expert here for some 1 on 1 help. Your first session is always free. 

Are you still looking for help with the VLOOKUP function? View our comprehensive round-up of VLOOKUP function tutorials here.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Solution examples
On the Grade Average worksheet, select G7 and type "Average." In cell G8, use a formula to generate the average of the contents in Cells B8:F8. Use the fill handle to populate your results through G10. The syntax for the Excel Average function is the following: AVERAGE(argument1, [argument2],...). Arguments can be numbers, named ranges, cell references that contain numbers, or arrays. Select Cell A12, and enter "Class Average." Use a formula to generate the average of IP Assignment 1 in cell B12. Use the fill across handle to populate your results of averaging the other assignments to F12
Solved by Z. A. in 40 mins
I need help calculating average time elapsed. It is in dd:hh:mm:ss text format and so I can't calculate using =AVERAGEIF
Solved by O. E. in 11 mins
I contacted you yesterdaya bout how to use the =AVERAGE function, and for real numbers it works fine, but I tried to get the expert to explain to me how to use the =AVERAGE function when the cells have formulas in them that generate '0' value, so the AVERAGE function would ignore these cells in the averaging method, but got no answer. So, I need to know how use the =AVERAGE function so that when there are formulas in the selected cells to average, that EXCEL would ignore those cells like they have real numbers in them, which seems to work fine. Please advise...
Solved by C. J. in 30 mins
I need an IF formula where, IF there is a manual adjustment in a whole column of 100% values (say someone changes one to 90%) would say "Yes" or "No". Tried to solve this with =IF(AVERAGE(...)=100%, "No", "Yes") but it is kind of sloppy).
Solved by M. H. in 20 mins
IF(AVERAGE(C6+E6+G6)>=5000,TRUE,FALSE) I am using AND function and it is not giving me the correct answer
Solved by G. J. in 24 mins

Leave a Comment

1 Comment threads
0 Thread replies
Most reacted comment
Hottest comment thread
1 Comment authors
Raghav Recent comment authors
newest oldest

help with this calculating average?

Subscribe to

Get updates on helpful Excel topics

Subscribe to

Did this post not answer your question?
Get a solution from connecting with the expert

Another blog reader asked this question today on Excelchat:

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
Trusted by people who work at, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc