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.
- 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])
- Now, you will get the result ** in the **cell F5.
- Finally, after copying down the column , this formula will return a running total at each row.
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:
Top comments (0)