Excel function COUNTIF

The COUNTIF function returns the number of cells in a range that meet certain criteria.

Select the COUNTIF function and then enter the range of cells to verify, along with the criteria.

In this example, we will count the number of times that "yes" appears:

countif function

Click OK.

The number of times that "yes" appears will be displayed: