Excel Formulas to Count Rows that meets Internal Criteria!!
Tags: excelformula, excelformulas
Published: 2020-11-04 11:37:38

---
title: Excel Formulas to Count Rows that meets Internal Criteria!!
published: true
date: 2020-11-04 08:57:39 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-count-rows-that-meets-internal-criteria/
---

This page will show the **Formulas to count the rows in a table that meets internal, calculated criteria in Excl Office 365**. It also describes counting the rows without using a helper 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)

[![Formulas to count the rows that meets internal criteria](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Formulas-to-count-the-rows-that-meets-internal-criteria.png)](https://geekexcel.com/excel-formulas-to-count-rows-that-meets-internal-criteria/formulas-to-count-the-rows-that-meets-internal-criteria/#main)<figcaption id="caption-attachment-16850">Formulas to count the rows that meet internal criteria</figcaption>
## General Formula:

- To count the rows in a table that meets internal criteria in Excel, use the below formula.

**=[SUMPRODUCT](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)(–([logical\_expression](https://geekexcel.com/logical-functions-in-microsoft-excel-365-simple-guide/)))**

## Syntax Explanations:

- **SUMPRODUCT** – This function is used to multiply the corresponding arrays or ranges and returns as the sum of the products. Read more on the **[SUMPRODUCT Function](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)**.
- **Logical\_expressions** – In Excel, it is used to compare the values in a row or column. Read more on the **[Logical Functions](https://geekexcel.com/logical-functions-in-microsoft-excel-365-simple-guide/)**.
- **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.
- **Minus Operator (-)** – This symbol will help to subtract any two values.

## Example:

- In the below example image, we will give the input ranges in **Column C** and **Column D**.
- Then, enter the given formula in the selected area.
- After that, it displays the result in **Cell G4** as shown in the given image.

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

## Verdict:

From this article, you can get to know the simple **formula used for counting the rows in a table that meets the internal criteria in Excel Office 365**. Hope that this article is useful to you. If you have any **suggestions,** leave it in the below comment box. 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 for Counting Cells that Contain Odd Numbers!!](https://geekexcel.com/excel-formulas-for-counting-cells-that-contain-odd-numbers/)**
- **[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 numbers in Excel Office 365!!**](https://geekexcel.com/formulas-to-count-cells-that-contain-numbers-in-excel-office-365/)