Excel Formulas to Count Rows that meet Multiple OR Criteria!!
Tags: excelformula, excelformulas
Published: 2020-11-07 11:54:53

---
title: Excel Formulas to Count Rows that meet Multiple OR Criteria!!
published: true
date: 2020-11-07 09:08:47 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-count-rows-that-contain-multiple-or-criteria/
---

Here, we will show the **Formulas to count the rows that meet multiple OR criteria in Excel Office 365**. You can also learn the basic syntax and explanations 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 meets multiple OR criteria](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Formulas-to-count-rows-that-meets-multiple-OR-criteria.png)](https://geekexcel.com/excel-formulas-to-count-rows-that-contain-multiple-or-criteria/formulas-to-count-rows-that-meets-multiple-or-criteria/#main)<figcaption id="caption-attachment-17099">Formulas to count rows that meet multiple OR criteria</figcaption>
## General Formula:

- The following formula helps to count the rows with multiple OR criteria.

**=[SUMPRODUCT](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)(–((criteria1)+(criteria2)>0))**

## Syntax Explanations:

- **SUMPRODUCT ** – In Excel, the [**SUMPRODUCT Function**](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/) will multiply the corresponding array or table then, returns as the sum of the products.
- **Criteria** – It is the specific value that you want to be count.
- **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.
- **Plus operator (+)** – This symbol is used to add the values.
- **Minus Operator (-)** – This symbol will help to subtract any two values.

## Example:

- The below image shows how to count the rows that meet multiple criteria.
- First, we will give the input values in **Column C** and **Column D**.
- Then, enter the formula in the selected area.
- After applying the formula we will get the output in selected **Cell G3**.

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

## Verdict:

In this article, you can learn the **Formulas to count the number of rows that contain multiple OR criteria in Excel Office 365**. Hope that this article is useful to you. Kindly, drop your **feedback** in the below comment box. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- **[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 for Counting Cells that Contain Odd Numbers!!](https://geekexcel.com/excel-formulas-for-counting-cells-that-contain-odd-numbers/)**
- [**Formulas to Count the Rows that meet Multiple Internal Criteria in Excel!!**](https://geekexcel.com/formulas-to-count-the-rows-that-meets-multiple-internal-criteria-in-excel/)