Excel Formulas to Count Visible Rows in a Range!!
Tags: excelformula, excelformulas
Published: 2020-11-18 10:41:43

---
title: Excel Formulas to Count Visible Rows in a Range!!
published: true
date: 2020-11-17 12:01:27 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-count-visible-rows-in-a-range/
---

Here, we will see the formulas to count the visible rows in a range in Excel Office 365. 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 in a range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Formulas-to-count-visible-rows-in-a-range.png)](https://geekexcel.com/excel-formulas-to-count-visible-rows-in-a-range/formulas-to-count-visible-rows-in-a-range/#main)<figcaption id="caption-attachment-17483">Formulas to count visible rows in a range</figcaption>
## General Formula:

- The below formula will help to count the visible rows in Excel.

**=[SUBTOTAL](https://geekexcel.com/excel-subtotal-function-in-office-365-with-examples/)(3,range)**

## Syntax Explanations:

- **SUBTOTAL** -The **[SUBTOTAL Function](https://geekexcel.com/excel-subtotal-function-in-office-365-with-examples/)** returns an aggregate result in a list or database.
- **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.

## Example:

- Let’s consider the below image, to count the visible rows in a range.
- First, you need to give input.
- In the below image, we will give the input in **Column B**.
- Then, enter the given formula in the formula bar.
- After applying the formula, we will get the result in **Cell G3**.

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

## Conclusion:

From the above article, we have described the **formulas used for counting the visible rows in a range in Excel Office 365**. Hope that this article is useful to you. If you have any **suggestions,** drop it in the below comment section. 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 that Begins with Certain Number!!](https://geekexcel.com/excel-formulas-to-count-numbers-that-begins-with-certain-number/)**
- **[Formulas for Counting the Number of Bold Cells in a Range In Excel!!](https://geekexcel.com/formulas-for-counting-the-number-of-bold-cells-in-a-range-in-excel/)**
- **[Excel Formulas To Count All Distinct Values in a Range in Excel 365!!](https://geekexcel.com/excel-formulas-to-count-all-distinct-values-in-a-range-in-excel-365/)**
- [**Formulas for Counting the Rows that Contain Specific Values in Excel!!**](https://geekexcel.com/formulas-for-counting-the-rows-that-contain-specific-values-in-excel/)