How to Add Running Totals in Microsoft Excel

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.

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.

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.

• 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.

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.

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.

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. Keep Learning!!