Excel Formulas to use COUNTIFS with variable table column!!
Tags: excelformula, excelformulas
Published: 2021-10-28 04:18:06

---
title: Excel Formulas to use COUNTIFS with variable table column!!
published: true
date: 2021-10-27 06:33:13 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-use-countifs-with-variable-table-column/
---

We know that the  **COUNTIFS function**  in Excel can count on multiple criteria. It takes arguments as a couple of criteria, range, and criteria. Here, I will introduce you to some easy **formulas to use COUNTIFS with the variable table column** in Excel. Let’s get started!! 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

- You can use the below formula to COUNTIFS with the variable table column in Excel.

```
=COUNTIFS([INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(Table,0,[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)(name,Table[#Headers],0)),criteria))

```

## Syntax Explanation

- **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.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **COUNTIFS** – This function helps to create a cell address from a given row and column.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **MATCH ** – The **[MATCH function](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)** helps to locate the position of a lookup value in a row, column, or table.
- **Table ** – It contains list of values.

## Practical Example

Let’s consider the below example image.<ins></ins>

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

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

- To use **COUNTIFS with a variable table column**  **for swim** , you have to use the following formula in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
=COUNTIFS([INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(Table1,0,[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)(G5,Table1[#Headers],0)),"x")

```

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

- Then, you will get the **result for the swim** in the **cell H5**.

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

- Now, to use **COUNTIFS with a variable table column for run** , you have to use the following formula in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
=COUNTIFS([INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(Table1,0,[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)(G6,Table1[#Headers],0)),"x")

```

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

- After that, you will get the **result for the run** in the **cell H6**.

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

- To use **COUNTIFS with a variable table column for bike** , you have to use the following formula in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
=COUNTIFS([INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(Table1,0,[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)(G7,Table1[#Headers],0)),"x")

```

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

- Finally, you will get the **result for the bike** in the **cell H7**.

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

## Wrap-Up

From this tutorial, you can get some clarification on **formulas to use COUNTIFS with the variable table column** in Excel. If you have any other  **ideas**  or  **questions** , do share them with us here in the  **comment**  section below. 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/) **!!**

**Keep Reading:**

- **[Excel Formulas to Count Variable Range with COUNTIFS Function!!](https://geekexcel.com/excel-formulas-to-count-variable-range-with-countifs-function/)**
- **[Excel Formulas to Remove the Text By Variable Position ~ Quickly!!](https://geekexcel.com/excel-formulas-to-remove-the-text-by-variable-position/)**
- **[Formulas to Get the Maximum Value with Variable Columns!!](https://geekexcel.com/excel-formulas-maximum-value-with-variable-columns/)**
- **[Excel Formulas to Count Numbers by Range with COUNTIFS Function!!](https://geekexcel.com/excel-formulas-to-count-numbers-by-range-with-countifs-function/)**
- **[Formulas to Create a Summary Count by Month with COUNTIFS Function](https://geekexcel.com/formulas-to-create-summary-count-by-month-with-countifs-function/)**