How to Add Running Totals in Microsoft Excel
Tags: addrunningtotalsinex, exceltutorials, excel
Published: 2021-11-16 04:06:16

---
title: How to Add Running Totals in Microsoft Excel
published: true
date: 2021-11-12 14:25:00 UTC
tags: AddRunningTotalsinEx,ExcelTutorials,Excel
canonical_url: https://geekexcel.com/simple-ways-to-add-running-totals-in-microsoft-excel-365/
---

## Add Running Totals in Excel:

This article will guide you to know the simple ways to  **Add Running Totals**  in Excel 365. Running Totals get changed each time new data is added or modified in the table in Excel. Let’s step into this article and see the ways to  **Add Running Totals**  in Excel.

## Calculate Running Totals with a Simple Formula:

Here we are going to see how to calculate  **Running Totals**  with a  **Simple Formula**  using  **+** Operator. For example, we calculate Running Totals based on one person’s daily expenditure. The following table shows the details of everyday spending.

![](https://geekexcel.com/wp-content/uploads/2020/07/mi-7.png)

To calculate  **Running Totals** , for the above table. It would help if you used a simple formula that is:

1. On the first row in the total column, you have to give ”  **=b2 “**. Press Enter to get the result.
2. Then, you have to enter ”  **=c2 + b3**  ” in the second row of the total column. Then Click Enter to get the result.
3. You can easily calculate the ** Running Totals**  for the remaining rows in the table by  **dragging them to the last cell**  in the total column. It will apply the formula for all the cells and calculate the Running Totals.

![](https://geekexcel.com/wp-content/uploads/2020/07/mi-8.png)

If we insert or delete rows in the table, some changes will happen in the running totals.

- Inserting a new row will leave a  **gap**  in the table. You can fix this by copying the formula down from the first cell above the newly inserted row and  **dragging**  it to the last row to  **calculate Running Totals**.

![](https://geekexcel.com/wp-content/uploads/2020/07/mi-9.png)

- If you **delete** any row in the table, it will show **#REF! Error**. You can fix it by copying the formula down from the last error-free cell to the last cell in the table.

![](https://geekexcel.com/wp-content/uploads/2020/07/mi-10.png)

## Calculate Running Totals with a SUM Formula:

Instead of using ** the ” + “**  Operator, you can use  **SUM Formula**  to calculate  **Running Totals**  Easily.

- You can enter the formula ” **=SUM(b2 + c1)** ” below the text cell in the column.  **SUM Function**  will consider any text in a cell as ** 0**.
- Then Drag this formula to the last cell in that column to get the Running Totals.
- If you want to  **insert/delete**  rows in the table, you can see the same  **errors**. You can fix this by doing the same method you did in ** calculating Running Totals**   **with a Simple Formula**.

![](https://geekexcel.com/wp-content/uploads/2020/07/mi-11.png)

## Calculate Running Totals with a Partially Fixed Range:

Here we will use the  **SUM Function ** to reference the  **Expenditure**  column and use  **Partially Fixed Range**  to calculate  **Running Totals**.

- To do this, you need to enter the formula ” **=SUM($b$2:b5)** ” to calculate running totals in the table with a partially fixed range.
- If you insert/delete rows in the table, you will have the same problem that happened before. Use the same ways to fix it.

![](https://geekexcel.com/wp-content/uploads/2020/07/mi-12.png)

## Verdict:

In this article, you can understand the simple ways to  **Add Running Totals**  in Excel 365 with examples. Kindly share your  **feedback**  in the comment section. Thanks for visiting [**Geek Excel.**](https://geekexcel.com/) Keep Learning!!