If you are looking for some of the easiest ways to count rows with text in Excel, then you will find this article worthy of it. Sometimes different texts and numbers and other types of variables get mixed up in a column. So, if you want to count rows based on texts, then letâ€™s go through this article.

## How to Count Rows with Text in Excel: 7 Ways

Here, I have used the following table, where in the **Size** column, I have both text and number variables. Furthermore, the number of rows will be counted here based on the texts in this column. So, using the following example, I will try to explain the methods.

__Method-1__: Use of COUNTIF Function to Count Rows with Any Text

To count the number of texts in the **Size** column you have to use **the COUNTIF function **here. Here, I have added a column named **Count **for counting the number of texts.

** Steps:**âž¤ Firstly, select the output cell in the

**Count**column.

**âž¤ Secondly, type the following function here:**

`=COUNTIF(C5:C13,"*")`

Here, **C5:C13** is the range, and ***** is the *wildcard *that matches any number of text characters.

âž¤ Subsequently, press **ENTER**.**
**âž¤ Now, it will show up the value of texts in the

**Size**column.

__Method-2__: Counting Rows with Specific Text in Excel

Suppose I will now search in the **Product **column how many *Shirts *are there. To do this you have to use the **COUNTIF **function and enter the specific text name here.

** Steps:**âž¤ First, select the output cell in the

**Count**column.

**âž¤ Secondly, type the following function here:**

`=COUNTIF(B5:B13,"*Shirt*")`

Here, **B5:B13** is the range, and between the **wildcards**, **Shirt **is used for searching this text.

âž¤ Then, press **ENTER**.**
**âž¤ Now, it will show up the number of shirts in the

**Product**column.

__Method-3__: Combination of Functions to Count Rows Based on Multiple Criteria

Suppose you now want to find in the **Product **column how many *Shirts* and *Shoes* are there. To do this you have to use** the SUMPRODUCT function** here.

** Steps:**âž¤ First, select the output cell in the

**Count**column.

**âž¤ Secondly, type the following function here:**

`=SUMPRODUCT(--(ISNUMBER(FIND("Shirt",B5:B13))+ISNUMBER(FIND("Shoe",B5:B13))>0))`

**Formula Breakdown**

Here, *B5:B13* is the range. Then, using **the FIND function****,**Â you will find the desired texts **Shirt** and **Shoe.
**After that,

**the**

**ISNUMBER function**will return an array containing

**1**and

**0**.

**1**will be for the case where the criteria are met and

**0**is for not meeting the criteria.

Finally, the

**SUMPRODUCT**function will add up the values.

__âž¤ After that, press __**ENTER**.**
**âž¤ So, it will show up the number of shirts and shoes in the

**Product**column.

__Method-4__: Counting Rows with Non-Text Values

If you want to find the non-text values like numbers in the **SizeÂ **column**,**Â then you have to use the** COUNTIF **function here.

** Steps:**âž¤ First, select the output cell in the

**Count**column.

**âž¤ Secondly, type the following function here:**

`=COUNTIF(C5:C13,"<>*")`

Here, *C5:C13* is the range, and before the *wildcard***, <>** is used which means *Not Equal to*.

âž¤ Consequently, press **ENTER**.

âž¤ Then, it will show up the number of numerical values in the **Size **column.

__Method-5__: Applying SUMPRODUCT & ISTEXT Functions

You can use the **SUMPRODUCT **function to get the number of texts in the **Size **column.

** Steps:**âž¤ First, select the output cell in the

**Count**column.

**âž¤ Secondly, type the following function here:**

`=SUMPRODUCT(--ISTEXT(C5:C13))`

Here, *C5:C13* is the range, **the ISTEXT function** will check out if there are texts and then will return **TRUE** and if there are no texts then it will return **FALSE**. Then **—** will convert *TRUE *into *1* and *FALSE *into *0*. Then the **SUMPRODUCT **function will sum up the values.

âž¤ Then, press **ENTER**.**
**âž¤ As a result, it will show up the number of texts in the

**Size**column.

__Method-6__: Use of SUM, IF & ISTEXT Functions to Count Rows with Text

Here, you can count the number of texts by using the **array formula** as well.

** Steps:**âž¤ First, select the output cell in the

**Count column**.

**âž¤ Secondly, type the following function here.**

`=SUM(IF(ISTEXT(C5:C13),1))`

Here, *C5:C13* is the range, **the IF function **will return *1* if there is text and then **the SUM function** will sum up these values.

âž¤ Subsequently, press **ENTER**.**
**âž¤ Now, it will show up the number of texts in the

**Size**column.

**Note:**

*If you are using an Excel version other than Excel 365, then you may need to press*

**CTRL+SHIFT+ENTER**.Â Â__Method-7__: Counting Rows with Filtered Texts

Suppose you want to count texts in a filtered data table but in this case, you will get the total text values not only the shown values in the filtered column. But you can count the visible values only after filtering by following this method.

Before filtering data, you just have to do some extra tasks like the one below.

** Steps:**âž¤ Firstly, select cell

**E5**of the

**Filtered Value**column.

**âž¤ Secondly, type the following formula:**

`=SUBTOTAL(103,C5)`

Actually, to identify all hidden cells, filtered out and hidden manually, **function_num** is used as **103**. And **C5** is the *reference*.

âž¤ Then, press **ENTER**.

âž¤ After that, drag down the *Fill handle tool*.

Now, you will get **1** for all of the rows.

âž¤ Now, you can filter the values according to your needs.

âž¤ Then, select the output cell in the **Count **column.

âž¤ Then, type the following formula:

`=COUNTIFS(C5:C13, "*", E5:E13, 1)`

Here, to count the number of visible texts, you can use **the COUNTIFS function**.

âž¤ After that, press **ENTER**.**
**âž¤ As a result, it will return the number of texts visible in the

**Size**column.

Here, you can do the aforementioned task by typing only the following formula.

`=SUMPRODUCT(SUBTOTAL(103, INDIRECT("C"&ROW(C5:C13))), --(ISTEXT(C5:C13)))`

Otherwise, use the following formula.

`=SUMPRODUCT(SUBTOTAL(103, OFFSET(C5:C13, ROW(C5:C13) - MIN(ROW(C5:C13)),,1)), -- (ISTEXT(C5:C13)))`

Here, by the following steps, you can change the filtered text.

- First, click on the drop-down arrow >> then from the list >> select required texts >> press
**OK**.

## Practice Section

For doing practice by yourself we have provided a pactice section like below for each method in each sheet on the right side. Please do it by yourself.

**Download Practice Workbook**

## Conclusion

Here, in this article, I tried to cover the easiest ways to count rows with text in Excel effectively. Hope you will find it useful. If you have any suggestions or questions, feel free to share them with us.

**<< Go Back to Count Rows | Formula List | Learn Excel**