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

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

Sample data

• Then, to create a running total in an Excel Table, you have to use the following formula in formula bar.

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

Use the Formula

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

Result in Cell F5

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

Output

Check this too:

• Simple Ways to Add Running Totals in Microsoft Excel 365
• 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!! *And Excel Formulas *!!

Related Articles:

• Formulas to calculate the running total from a range in Excel!!
• Excel Formulas for Running Count of Occurrence in a List!!
• Formulas to Create the Running Count Group by N Size!!
• Excel Formulas to calculate Total rows in range in Excel Office 365!!