Formulas to Count Rows with Multiple OR Criteria Using SUMPRODUCT!!
Tags: excelformula, excelformulas
Published: 2020-11-20 12:05:55

---
title: Formulas to Count Rows with Multiple OR Criteria Using SUMPRODUCT!!
published: true
date: 2020-11-20 12:00:39 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formulas-to-count-rows-with-multiple-or-criteria-using-sumproduct/
---

In this short tutorial, we will see the **formulas used to count the matching rows with multiple OR criteria using the SUMPRODUCT Function in Excel Office 365**. 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 with multiple OR criteria using SUMPRODUCT](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Formulas-to-count-rows-with-multiple-OR-criteria-using-SUMPRODUCT.png)](https://geekexcel.com/formulas-to-count-rows-with-multiple-or-criteria-using-sumproduct/formulas-to-count-rows-with-multiple-or-criteria-using-sumproduct/#main)<figcaption id="caption-attachment-17704">Formulas to count rows with multiple OR criteria using SUMPRODUCT</figcaption>
## General Formula:

- Use the below formula to count the rows with multiple OR criteria.

**=[SUMPRODUCT](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)([ISNUMBER](https://geekexcel.com/how-to-use-isnumber-function-in-microsoft-excel-365/)([MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)(range1,{“A”,”B”},0))\*ISNUMBER(MATCH(range2,{“X”,”Y”},0)))**

## Syntax Explanations:

- **SUMPRODUCT** – In Excel, this function will multiply the corresponding arrays or ranges and returns the sum of the products. Read more on the [**SUMPRODUCT Function**](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/).
- **ISNUMBER** – It helps to return TRUE when a cell contains a number, and FALSE if there will not be a number. Read more on the [**ISNUMBER Function**](https://geekexcel.com/how-to-use-isnumber-function-in-microsoft-excel-365/).
- **MATCH** – The [**MATCH function**](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)in Excel will help to locate the position of a lookup value in a row, column, or table.
- **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.
- **Range** – It represents the input range from your worksheet.
- **Criteria (A, B & X, Y)** – It is the condition that is used to count the values.
- **Multiplication (\*)** – In this symbol will multiply any two values or numbers.

## Example:

- In the below screenshot, we will enter the input ranges in **Column B** and **Column C.**
- Then, enter the criteria in **Column E and F**.
- After that, apply the given formula in the formula bar section.
- Finally, we will get the result in **Cell F7**.

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

## Wind-Up:

Here, we explained the **formulas to count the rows with multiple OR criteria using the SUMPRODUCT Function 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/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Related Articles:

- **[Formulas for Counting Cells with Multiple OR Criteria in Excel 365 !!](https://geekexcel.com/formulas-for-counting-cells-with-multiple-or-criteria-in-excel-365/)**
- **[Excel Formulas to Count Rows that meet Multiple OR Criteria!!](https://geekexcel.com/excel-formulas-to-count-rows-that-contain-multiple-or-criteria/)**
- [**Formulas to Find Sum of All Digits/Numbers in a Cell in Excel!!**](https://geekexcel.com/formulas-to-find-sum-of-all-digits-numbers-in-a-cell-in-excel/)