Excel formulas to calculate running count in Table!!
Tags: excelformula, excelformulas
Published: 2021-10-29 03:18:27

---
title: Excel formulas to calculate running count in Table!!
published: true
date: 2021-10-28 07:00:53 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/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](https://geekexcel.com/how-to-use-excel-count-function-in-office-365-with-examples/) 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

- 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](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.
- **SUM** – The [**SUM function**](https://geekexcel.com/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.

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

- Then, to create a running count 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/)**.

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

```

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Use-the-Formula-15.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.png)<figcaption>Result in Cell F5</figcaption>

- Finally, after **copying down the column** , this formula will return a **running count for each color** in the Color column.

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

**Check these too:**

- [Excel Formulas to Count table columns in Excel 365!!](https://geekexcel.com/excel-formulas-to-count-table-columns-in-excel-365/)
- [How To Count Worksheets In Multiple Files?](https://geekexcel.com/how-to-count-worksheets-in-multiple-files-in-excel-vba/)

## 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](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Also:**

- **[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/)**
- **[Excel Formulas to Create the Running Count Group by N Size!!](https://geekexcel.com/excel-formulas-to-create-the-running-count-group-by-n-size/)**
- **[Simple Ways to Add Running Totals in Microsoft Excel 365](https://geekexcel.com/simple-ways-to-add-running-totals-in-microsoft-excel-365/)**
- **[How To Determine if an application is available using VBA in Excel?](https://geekexcel.com/how-to-determine-if-an-application-is-available-using-vba-in-excel/)**