How to Calculate Running Average in Excel (3 Ideal Examples)

In this post, you will learn how to calculate the running average of a data set. A business generates a considerable amount of data every year. Most of the data is related to time. One useful way to analyze your data is to find the average. For example, if you run a website or blog like me, you will count how many visitors are coming to your blog every month. This is an example; your business or website generates much more data. In this article, we shall learn how to calculate the Running Average in Excel.


Download Practice Workbook

Download the following workbook to practice by yourself.


3 Ideal Examples to Calculate Running Average in Excel

Let’s explain what the running average is with an example. In the image below, you are seeing an Excel workbook titled Running Average. In the Visitors worksheet, you are seeing some data. Under the Month column, there are twelve months: from Jan to Dec. Under the Visitors in my blog column, you are seeing the total number of visitors coming to my blog every month. The blog visitors have increased almost three times in the month of November. In Jan it was around 3 thousand and in the month of November, it is around 8 thousand and 500 hundred.

running average excel


1. Compute Regular Running Average with Excel AVERAGE Function

There are many default Excel Functions that we can use to create formulas. The AVERAGE function helps us to find the average of specific numbers. Therefore, follow the steps below to perform the task.

STEPS:

  • First, select cell D5 and insert the AVERAGE function.
=AVERAGE($C$5:C5)
  • Here, I click cell C5 as the argument of the AVERAGE function.
  • I’ll make the C5 reference an absolute reference, so press the F4 key on your keyboard.
  • Thus, cell reference C5 turns into an absolute cell reference.
  • Then, insert the range operator and again insert the C5 cell reference.
  • Lastly, place the closing parenthesis after the formula.

Compute Regular Running Average with Excel AVERAGE Function

  • I press Enter.
  • The formula returns a value of 2901. This formula actually finds out the average of cell C5.
  • Next, I select the cell and then copy the formula for the next cell.
  • The formula returns 3022.5. I select the cell and click on the formula bar. You see this formula selects cells C5 to C6. So the formula calculates the average of cells C5 to C6. I am sure you are getting the idea of how the running average actually works.

  • Now I copy the formula for other cells in the column.
  • Afterward, I select the last cell and click on the formula bar. You see this formula works on all the cells in the column, from cells D5 to D16.

  • So, this is how you can calculate the running average of some values.

Read More: How to Exclude a Cell in Excel AVERAGE Formula (4 Methods)


2. Calculate 3 Months Running Average in Excel

Moreover, we’ll show the process to get the ruining average of 3 months which is more practical for any business. So, learn the following steps.

STEPS:

  • Under the 3-month Running Average column, I select the third cell E7. As we are going to find out the running average of 3 months, we have to start from the third month. You cannot find out 3-month running averages using only 1 or 2 values. The formula is:
=AVERAGE(C5:C7)
  • Here, I insert the average function in cell E7, I select cells C5 to C7. This time I am not going to turn any cell references to absolute as when I shall copy this formula to the cells below, I want that for every formula it will select the last three values.
  • So I close the function and press Enter.

Calculate 3 Months Running Average in Excel

  • Consequently, the formula returns 3202. It is the same as this running average. The reason is this running average finds out the average of these three values and this 3-month running average also does the same.
  • Now I copy the formula to other cells in the column.
  • In this way, you’ll get all the 3-month running averages.

Read More: Moving Average Formula in Excel (8 Uses with Examples)


Similar Readings


3. Insert SUM Function for Determining Running Average

However, you can use the SUM function and the COUNT function in excel to determine the average of some values. Hence, follow the process.

STEPS:

  • Firstly, select cell D5.
  • Then, insert the formula:
=SUM($C$5:C5)/COUNT($C$5:C5)

Insert SUM Function for Determining Running Average

NOTE: SUM($C$5:C5) returns the sum of C5:C5. The COUNT($C$5:C5) formula returns the number count, which is 1.
  • Subsequently, press Enter.
  • After that, use AutoFill to fill the rest.
  • Hence, it’ll return the running averages in cells D5 to D16.

Read More: [Fixed!] AVERAGE Formula Not Working in Excel (6 Solutions)


Conclusion

Henceforth, you will be able to calculate the running average in excel following the above-described examples. Keep using them and let us know if you have more ways to do the task. Follow the ExcelDemy website for more articles like this. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Kawser

Kawser

Hello! Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share them here. Not only how-to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned! You can checkout my courses at Udemy: https://www.udemy.com/user/exceldemy/

2 Comments
  1. I love this article very much and I am just learning it for the first time.

    Thanks.

  2. Great explanation. I used it and it worked. Thanks for the insights.

Leave a reply

ExcelDemy
Logo