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 T****ext**

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