Excel Formulas to Count Visible Rows Only with Criteria!!
Tags: excelformula, excelformulas
Published: 2020-11-18 12:00:54

---
title: Excel Formulas to Count Visible Rows Only with Criteria!!
published: true
date: 2020-11-18 11:56:05 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-count-visible-rows-only-with-criteria/
---

Here, we will see the **formulas to count the visible rows only with specific criteria in Excel Office 365**. You can also learn the basic syntax and its explanations. Let’s get into this article!! 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 visible rows only with criteria](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Formulas-to-count-visible-rows-only-with-criteria.png)](https://geekexcel.com/excel-formulas-to-count-visible-rows-only-with-criteria/formulas-to-count-visible-rows-only-with-criteria/#main)<figcaption id="caption-attachment-17531">Formulas to count visible rows only with criteria</figcaption>
## General Formula:

- To count the visible rows only with criteria, use the below formula.

**=[SUMPRODUCT](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)((range=criteria)\*([SUBTOTAL](https://geekexcel.com/excel-subtotal-function-in-office-365-with-examples/)(103,[OFFSET](https://geekexcel.com/use-offset-function-in-microsoft-excel-365/)(range,[ROW](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)(range)-[MIN](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)(ROW(range)),0))))**

## Syntax Explanations:

- **SUMPRODUCT** – In Excel, this function will help to 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/).
- **SUBTOTAL** -The **[SUBTOTAL Function](https://geekexcel.com/excel-subtotal-function-in-office-365-with-examples/)** returns an aggregate result in a list or database.
- **OFFSET** – It will return a reference to a range constructed in parts which is a starting point, a row, and column offset, and a final height and width in rows and columns. Read more on the [**OFFSET  Function**](https://geekexcel.com/use-offset-function-in-microsoft-excel-365/).
- **ROW** – The **[ROW function](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)** returns the row number for reference.
- **MIN** – This function helps to find the smallest numeric value from the range of input values. Read more on the [**MIN Function**](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/).
- **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.
- **Minus Operator (-)** – This symbol will help to subtract any two values.
- **Multiplication (\*)** – In this symbol will multiply any two values or numbers.

## Example:

- In the below image, we will show how to count the visible rows only with criteria.
- First, we will give the input values in **Column B** and **Column C**.
- Then, enter the given formula in the formula bar section.
- Finally, it will display the result as shown below.

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

## Bottom-Line:

This article gives you clarification about the **formulas for counting the visible rows in a range only with criteria in Excel Office 365**. Hope you like this article. If you have any **doubts/queries,** don’t forget 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/) **!!**

### Read Also:

- **[Excel Formulas to Count Numbers by Range with COUNTIFS Function!!](https://geekexcel.com/excel-formulas-to-count-numbers-by-range-with-countifs-function/)**
- **[Excel Formula to Count the Occurrences of a Character in a String!!](https://geekexcel.com/excel-formula-to-count-the-occurrences-of-a-character-in-a-string/)**
- **[Formulas for Counting Unique Values in a Range with COUNTIF in Excel!!](https://geekexcel.com/formulas-for-counting-unique-values-in-a-range-with-countif-in-excel/)**
- [**Excel Formulas for Counting Multiple Criteria with NOT Logic!!**](https://geekexcel.com/excel-formulas-for-counting-multiple-criteria-with-not-logic/)