In this article:

Moving Average in Google Sheets: Complete 2024 Guide

May 8, 2024

How to Calculate the Moving Average in Google Sheets

To calculate a simple moving average in Google Sheets for a series of values, you can use the AVERAGE function combined with a relative reference to create a rolling average.

For example, if you have your data in column A and you want to calculate a 3-day moving average, you could place the following formula in cell B4 (assuming your data starts in cell A1) to calculate the moving average for the first 3 data points and then drag the formula down to apply it to other cells


As you drag the formula down, it will calculate the moving average for each set of 3 cells in column A.


Let's create a small dataset that you can use to test the calculation of moving averages in Google Sheets. Suppose you have the following daily sales data for one week:

google sheets moving average

Here's how you can calculate a 3-day simple moving average for this data:

Step 1: Enter the Moving Average Formula 

To calculate the 3-day moving average starting from Wednesday (since the first two days don't have two preceding days to form a 3-day average), enter the following formula in cell C4:


moving average google sheets

Step 2: Apply the Formula to the Rest of the Week 

Drag the formula in C4 down to C8 to calculate the moving average for the rest of the week.

moving average in google sheets

In column C, you'll see the moving average for each day starting from Wednesday. Remember, the formula =AVERAGE(B2:B4) calculates the average of Monday, Tuesday, and Wednesday. As you drag the formula down, the range automatically adjusts to calculate the 3-day average for the subsequent days.

We hope that this article has helped you and given you a better understanding of how to calculate a simple moving average in Google Sheets. If you enjoyed this article, you might also like our articles on how to insert the delta symbol in Google Sheets and how to use the Venn diagram in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->