Formulas for Counting Rows that Matches Two or More Criteria in Excel!!
Tags: excelformula, excelformulas
Published: 2020-11-04 11:37:16

---
title: Formulas for Counting Rows that Matches Two or More Criteria in Excel!!
published: true
date: 2020-11-04 08:53:29 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formulas-for-counting-rows-that-matches-two-or-more-criteria-in-excel/
---

In this tutorial, we will describe the **Formulas for counting the rows in a table that matches two or more criteria in Excel Office 365**. You can also learn the basic syntax explanations with a neat example from this article. Let’s see them below!! 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)

[![Formulas to count rows that match two or more criteria](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Formulas-to-count-rows-that-match-two-or-more-criteria.png)](https://geekexcel.com/formulas-for-counting-rows-that-matches-two-or-more-criteria-in-excel/formulas-to-count-rows-that-match-two-or-more-criteria/#main)<figcaption id="caption-attachment-16875">Formulas to count rows that match two or more criteria</figcaption>
## General Formula:

- Use the below formula to count the rows that meet two or more conditions in Excel.

**=COUNTIFS(range 1, criteria 1, range 2, criteria 2)**

## Syntax Explanations:

- **COUNTIFS** – In Excel, this function will count the number of cells that match multiple criteria or conditions.
- **Range** – It represents the input values given in a worksheet.
- **Criteria** – It is the condition which helps to count the cells.
- **Comma symbol (,)** – It is a separator which helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

- Let’s consider the below example image to count the rows that match two or more criteria.
- First, you need to give the input values.
- Then, enter the formula with the specific criteria.
- After applying the formula you can get the results as given below.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Example-16.png)<figcaption id="caption-attachment-16874">Example</figcaption>

## Bottom-Line:

This page described the **Formulas for counting the rows in a table that matches two or more criteria in Excel Office 365**. Hope that this article is useful to you. If you have any suggestions, feel free to share it with us. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- **[Excel Formulas to Count the Cells that do not contain many Strings!!](https://geekexcel.com/excel-formulas-to-count-cells-do-not-contain-many-strings/)**
- **[Formulas to count cells that contain more than 100 characters in Excel!!](https://geekexcel.com/formulas-to-count-cells-that-contains-more-than-100-characters-in-excel/)**
- **[Excel Formulas to Count Cells that contain Specific Text!!](https://geekexcel.com/excel-formulas-to-count-cells-that-contain-specific-text/)**