Excel formulas to calculate running count in Table!!

Have you ever tried to calculate a running count in an Excel table? Do you have any good methods for solving this task in Excel? In this tutorial, I introduce some formulas which can quickly calculate a running count 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

• Use the below-given formula to calculate a running count in an Excel table.

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

Syntax Explanation

• Parenthesis () – The main purpose of this symbol is to group the elements.
• Comma symbol (,) – It is a separator that helps to separate a list of values.
• 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.
• SUM – The SUM function adds values to the cells.
• Minus Operator (-) – This symbol will help to subtract any two values.

Practical Example

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

Sample data

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

=[@Color]&" - "&SUM(--(INDEX([Color],1):[@Color]=[@Color]))

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 count for each color in the Color column.

Output

Check these too:

• Excel Formulas to Count table columns in Excel 365!!
• How To Count Worksheets In Multiple Files?

Closure

Hope you like this tutorial on how to calculate a running count in an Excel table. If you have any questions or suggestions regarding this lesson, feel free to use the comment section below to let us know.

Thank you so much for visiting Geek Excel!! *If you want to learn more helpful formulas, check out Excel Formulas *!!

Read Also:

• Formulas to calculate the running total from a range in Excel!!
• Excel Formulas for Running Count of Occurrence in a List!!
• Excel Formulas to Create the Running Count Group by N Size!!
• Simple Ways to Add Running Totals in Microsoft Excel 365
• How To Determine if an application is available using VBA in Excel?