How to Count Rows with Text in Excel (3 Examples)


You can use the following methods to count rows with particular text in Excel:

Method 1: Count Rows with Any Text

=COUNTIF(A2:A11, "<>")

Method 2: Count Rows with No Text

=COUNTBLANK(A2:A11)

Method 3: Count Rows with Specific Text

=COUNTIF(A2:A11, "Mavs")

The following examples show how to use each method with the following dataset in Excel:

Example 1: Count Rows with Any Text

We can use the following formula to count the number of rows with any text in column A:

=COUNTIF(A2:A11, "<>")

The following screenshot shows how to use this formula in practice:

We can see that there are 8 rows with any text in the Team column.

Example 2: Count Rows with No Text

We can use the following formula to count the number of rows with no text in column A:

=COUNTBLANK(B2:B11)

The following screenshot shows how to use this formula in practice:

We can see that there are 2 rows with no text in the Team column.

Example 3: Count Rows with Specific Text

We can use the following formula to count the number of rows with a value of “Mavs” in column A:

=COUNTIF(A2:A11, "Mavs")

The following screenshot shows how to use this formula in practice:

We can see that there are 3 rows with a value of “Mavs” in the Team column.

Additional Resources

The following tutorials explain how to perform other common tasks in Excel:

How to Count Specific Words in Excel
How to Count Unique Values by Group in Excel
How to Use COUNTIF with Multiple Ranges in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *