How to Count Rows with Value in Google Sheets

To count rows with a specific value in Google Sheets, you can use the COUNTIF function. The COUNTIF function takes two arguments: the range of cells to count and the criteria to count based on.

Here's a step-by-step guide on how to use COUNTIF to count rows with a specific value:

1. Open your Google Sheets document.
2. Click on an empty cell where you want the result to be displayed.
3. Type the following formula:

=COUNTIF(range, criteria)

Replace "range" with the range of cells you want to count and "criteria" with the value you want to count. For example, if you want to count how many cells in the range A1:A10 contain the value "Apple", the formula would be:

=COUNTIF(A1:A10, "Apple")

4. Press Enter to confirm the formula. Google Sheets will now display the number of rows containing the specified value.

Example

Let's say you have a list of fruits in column A, and you want to count how many times "Apple" appears in the list.

A
1  Apple
2  Banana
3  Apple
4  Orange
5  Apple
6  Banana
7  Pineapple
8  Apple

In this case, your formula would be:

=COUNTIF(A1:A8, "Apple")

After entering the formula, Google Sheets will show the result "4" in the selected cell, indicating that there are four rows containing the value "Apple".