You can use the following methods to count rows with a particular value in Google Sheets:

**Method 1: Count Rows with Any Value**

**=COUNTIF(A1:A10, "<>")**

**Method 2: Count Rows with No Value**

**=COUNTBLANK(A1:A10)**

**Method 3: Count Rows with Specific Value**

**=COUNTBLANK(A1:A10, "50")**

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

**Example 1: Count Rows with Any Value**

We can use the following formula to count the number of rows with *any* value in column B:

**=COUNTIF(B2:B11, "<>")**

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

We can see that there are **7** rows with any value in the Points column.

**Example 2: Count Rows with No Value**

We can use the following formula to count the number of rows with *no *value in column B:

**=COUNTBLANK(B2:B11)**

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

We can see that there are **3** rows with no value in the Points column.

**Example 3: Count Rows with Specific Value**

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

**=COUNTIF(B2:B11, "8")**

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

We can see that there are **3** rows with a value of “8” in the Points column.

**Additional Resources**

The following tutorials explain how to perform other common operations in Google Sheets:

Google Sheets: How to Filter for Cells that Contain Text

Google Sheets: How to Use SUMIF with Multiple Columns

Google Sheets: How to Sum Across Multiple Sheets

Method 3 at the top is incorrect. It should be =COUNTIF(A1:A10, “50”)

Hey there’s a typo in this. At the top, method 3 should be countif(…).