Count the Number of “Yes” / “No” in a Range

This post will guide you how to count yes and no answers in a column in Excel. How do I count the number of “Yes” or “No” responses in a range of cells with a formula in Excel. How do I count how many “yes” or “No” answers in Excel.

Assuming that you want to count the number of “Yes” answer in the range of cells B2:B6 or count the number of “No” answer in the same range, and you need to create a formula based on the COUNTIF function. Let’s see the below detailed introduction.

Count the Number of Yes Answer


To count the number of Yes answer in range of cells B2:B6, just type the following formula into a blank cell, such as: Cell E1, then press Enter key in your keyboard.

=COUNTIF(B2:B6,"Yes")

count number of yes no1

The number of Yes answer has been counted in the cell E1.

Count the Number of No Answer


To count the number of No answer in range of cell B2:B6, just type the following formula into a blank cell, such as: Cell E2 , then press Enter key in your keyboard.

=COUNTIF(B2:B6,"No")

count number of yes no2

The number of No answer has been counted in the cell E2.

Related Functions


  • Excel COUNTIF function
    The Excel COUNTIF function will count the number of cells in a range that meet a given criteria. This function can be used to count the different kinds of cells with number, date, text values, blank, non-blanks, or containing specific characters.etc.= COUNTIF (range, criteria)…

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar