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