- MS Excel Basics
- Excel - Home
- Excel - Getting Started
- Excel - Explore Window
- Excel - Backstage
- Excel - Entering Values
- Excel - Move Around
- Excel - Save Workbook
- Excel - Create Worksheet
- Excel - Copy Worksheet
- Excel - Hiding Worksheet
- Excel - Delete Worksheet
- Excel - Close Workbook
- Excel - Open Workbook
- Excel - Context Help

- Editing Worksheet
- Excel - Insert Data
- Excel - Select Data
- Excel - Delete Data
- Excel - Move Data
- Excel - Rows & Columns
- Excel - Copy & Paste
- Excel - Find & Replace
- Excel - Spell Check
- Excel - Zoom In-Out
- Excel - Special Symbols
- Excel - Insert Comments
- Excel - Add Text Box
- Excel - Undo Changes

- Formatting Cells
- Excel - Setting Cell Type
- Excel - Setting Fonts
- Excel - Text Decoration
- Excel - Rotate Cells
- Excel - Setting Colors
- Excel - Text Alignments
- Excel - Merge & Wrap
- Excel - Borders and Shades
- Excel - Apply Formatting

- Formatting Worksheets
- Excel - Sheet Options
- Excel - Adjust Margins
- Excel - Page Orientation
- Excel - Header and Footer
- Excel - Insert Page Breaks
- Excel - Set Background
- Excel - Freeze Panes
- Excel - Conditional Format

- Working with Formula
- Excel - Creating Formulas
- Excel - Copying Formulas
- Excel - Formula Reference
- Excel - Using Functions
- Excel - Builtin Functions

- Advanced Operations
- Excel - Data Filtering
- Excel - Data Sorting
- Excel - Using Ranges
- Excel - Data Validation
- Excel - Using Styles
- Excel - Using Themes
- Excel - Using Templates
- Excel - Using Macros
- Excel - Adding Graphics
- Excel - Cross Referencing
- Excel - Printing Worksheets
- Excel - Email Workbooks
- Excel- Translate Worksheet
- Excel - Workbook Security
- Excel - Data Tables
- Excel - Pivot Tables
- Excel - Simple Charts
- Excel - Pivot Charts
- Excel - Keyboard Shortcuts

- MS Excel Resources
- Excel - Quick Guide
- Excel - Useful Resources
- Excel - Discussion

# How to calculate running total /average in Excel?

The climax of a continuing sequence of partial totals of a particular data collection is what is known as a cumulative total, which is also referred to as a running total in certain circles. The use of a "running total," which shows the total as it increases and allows for the accumulation of data to be summarised as it occurs over time, is required in order to present the summary of the data.

This widely common method is used on a day-to-day basis by students and professionals who are assigned the task of using Excel to compute and calculate a range of intricate data and calculations.

It is not necessary to spend the time recording the sequence itself if you have a running total to keep track of the progress since it is not vital to know the particular numbers that are being used in the sequence.

## Step 1

Although this calculation can seem to be very complicated at first glance, the idea behind it is really quite simple and one that many of us are exposed to on a daily basis, regardless of whether or not we are the ones actually using it.

All of August's daily data can be found in the A column, while prices can be found in the B column. We need the average of the last three days in the C column.

## Step 2

Checking the current row number and exiting with the #NA code when there are less than n values is one approach to make it very evident that there is insufficient data. For the average for the last three days, you may, for instance, use

=IF(ROW()-ROW($B$4)+1<3,NA(),AVERAGE(B2:B4))

The first component of the formula consists of nothing more than the generation of a "normalized" row number, which begins with 1.

### Step 3

Depending on the layout of the worksheet and whether or not it's critical that all averages be computed using the same amount of data points, there are a few different approaches to take.

Because the AVERAGE function is set to automatically disregard text values and cells that are empty, it will continue to compute an average even if there are less values. The reason why it "works" in both C2 and C5 is because of this.

## Step 4

#N/A is what the algorithm gives back if the current row number is lower than 3. In every other case, the algorithm will produce a moving average just as it did previously. This replicates the behaviour of the Moving Average function included in the Analysis Toolpak, which generates the value #N/A until the first full period has been achieved.

## Conclusion

In this tutorial, we used a simple example to demonstrate how you can calculate the running average in Excel.

- Related Articles
- How to calculate the cumulative sum / running total of a column in Excel?
- How to calculate percentage of total in Excel?
- How to calculate average between two dates in Excel?
- How to calculate running count of occurrence in list in Excel?
- How to calculate average cells from different sheets in Excel?
- How to calculate the average rate of change in Excel?
- How to calculate the moving/rolling average in an Excel?
- How to calculate weighted average in an Excel Pivot Table?
- How to calculate average/compound annual growth rate in the Excel?
- How to calculate average speed from distance and time in Excel?
- How to calculate average without max and min values in Excel?
- How to calculate average age by year/month/date in Excel?
- How to add average/grand total line in a pivot chart in Excel
- How to calculate the average in a column based on criteria in another column in Excel?
- How to Average Filtered Cells/List in Excel?