Excel Formulas To Calculate Running total in Excel Table!!
Tags: excelformula, excelformulas
Published: 2021-10-29 03:18:43

---
title: Excel Formulas To Calculate Running total in Excel Table!!
published: true
date: 2021-10-28 08:26:28 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-calculate-running-total-in-excel-table/
---

Before entering this article, you need to know some basic formulas. Here, if you want to use running total in the table, what would you do? You are in the right place, we will help you with simple formulas to **calculate the [running total](https://geekexcel.com/simple-ways-to-add-running-totals-in-microsoft-excel-365/) in an Excel table**. Utilize the below-mentioned formulas!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## Generic Formula

- To calculate the running total in an Excel table, use the below **formula**.

```
=[SUM](https://geekexcel.com/sum-function/)([INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)([column],1):[@column])

```

## Syntax Explanation

- **SUM**  – In Excel, this function will help to add the values in the cells. Read more on the **[SUM Function](https://geekexcel.com/sum-function/)**.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **INDEX** – The **[INDEX function](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)** returns the value at a given position in a range or array. INDEX is frequently used together with the MATCH function.

## Practical Example

Use the following steps to calculate the running total in an Excel table.

- For instance, you need to  **create a sample data**  in Excel.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Sample-data-62.png)<figcaption>Sample data</figcaption>

- Then, to create a running total in an Excel Table, you have to use the following formula in **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
=[SUM](https://geekexcel.com/sum-function/)([INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)([Total],1):[@Total])

```

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Use-the-Formula-16.png)<figcaption>Use the Formula</figcaption>

- Now, you will get the  **result ** in the  **cell F5**.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Result-in-cell-F5-1.png)<figcaption>Result in Cell F5</figcaption>

- Finally, after  **copying down the column** , this formula will return a  **running total at each row**.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Output-48.png)<figcaption>Output</figcaption>

**Check this too:**

- [Simple Ways to Add Running Totals in Microsoft Excel 365](https://geekexcel.com/simple-ways-to-add-running-totals-in-microsoft-excel-365/)
- [Excel formulas to calculate running count in Table!!](https://geekexcel.com/excel-formulas-to-calculate-running-count-in-table/)

## Bottom-Line

This article gives you complete information about the ** ** simple formulas to  **calculate the running total in an Excel table**. Hope that this article is useful to you. Don’t forget to share your valuable  **feedback**  in the below section. Thank you so much for Reading!! Keep learning on **[Geek Excel](https://geekexcel.com/)!! **And [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Related Articles:**

- **[Formulas to calculate the running total from a range in Excel!!](https://geekexcel.com/formulas-to-calculate-the-running-total-from-a-range-in-excel/)**
- **[Excel Formulas for Running Count of Occurrence in a List!!](https://geekexcel.com/excel-formulas-for-running-count-of-occurrence-in-a-list/)**
- **[Formulas to Create the Running Count Group by N Size!!](https://geekexcel.com/excel-formulas-to-create-the-running-count-group-by-n-size/)**
- **[Excel Formulas to calculate Total rows in range in Excel Office 365!!](https://geekexcel.com/excel-formulas-to-calculate-total-rows-in-range-in-excel-office-365/)**