How can I use Google Sheets to count the number of “Yes” and “No” values in a specified range?

By /

Google Sheets is a powerful tool for managing data and performing calculations. One useful feature is the ability to count the number of “Yes” and “No” values in a specified range. This can be achieved by using the COUNTIF function, which allows users to specify a range of cells and a criteria to count the number of cells that meet that criteria. By setting the criteria to “Yes” or “No”, the function will count the number of cells in the range that contain those values. This allows users to quickly and accurately determine the number of “Yes” and “No” values in a specified range, providing valuable information for data analysis and decision making.

Google Sheets: Count Number of “Yes” and “No” Values in Range

You can use the following formulas to count the number of “Yes” and “No” values in a particular range in Google Sheets:

Formula 1: Count Number of “Yes” Values

=COUNTIF(B2:B21, "Yes")

Formula 2: Count Number of “No” Values

=COUNTIF(B2:B21, "No")

Method 3: Count Percentage of “Yes” Values

=COUNTIF(B2:B21, "Yes")/COUNTA(B2:B21)

Method 4: Count Percentage of “No” Values

=COUNTIF(B2:B21, "No")/COUNTA(B2:B21)

The following example shows how to use each formula in practice with the following dataset in Google Sheets that shows whether or not various students passed a particular course:

Example: How to Count “Yes” and “No” Values in Google Sheets

We can type the following formulas in the following cells to count the number of “Yes” and “No” values in the range B2:B21:

  • E1: =COUNTIF(B2:B21, “Yes”)
  • E2: =COUNTIF(B2:B21, “No”)
  • E3: =COUNTIF(B2:B21, “Yes”)/COUNTA(B2:B21)
  • E4: =COUNTIF(B2:B21, “No”)/COUNTA(B2:B21)

The following screenshot shows how to use these formulas in practice:

Google Sheets count yes and no

From the output we can see:

  • There were 9 total “Yes” values in column B.
  • There were 11 total “No” values in column B.
  • A total of 45% of cells were equal to “Yes” in column B.
  • A total of 55% of cells were equal to “No” in column B.

Note that the COUNTA function counts the number of cells in a range that are not empty.

By dividing the result of the COUNTIF function by the COUNTA function, we’re able to calculate the percentage of total values that are equal to either “Yes” or “No” in column B. 

Additional Resources

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

x

Related terms:

  1. How can I count the number of “Yes” and “No” values in a range using Google Sheets?
  2. Excel: Count Number of “Yes” and “No” Values in Range
  3. Count Specific Characters in Google Sheets How to count specific characters in google sheets?
  4. How can I apply conditional formatting to Yes/No values in Google Sheets?
  5. How can I use conditional formatting to highlight Yes/No values in Google Sheets?
  6. How can I count unique values in Google Sheets based on multiple criteria?
  7. How to Use an IF Function with Range of Values in Google Sheets
  8. Question: Google Sheets: Extract Top N Values from Range
  9. Student Question: Count Unique Values in Range Using VBA
  10. How do I create an [IF FUNCTION] to return [YES] or [NO] in [GOOGLE SHEETS]?