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:
The number of times that "yes" appears will be displayed: