Excel Function: COUNTIF
The Excel function COUNTIF is used to count the number of cells that meet a specific criteria.
Example of use
The goal here is to count the number of people registered for the course (in other words, the number of people who answered "Yes"):
Select the COUNTIF function and then enter the range of cells containing the responses as well as the "Yes" criteria:
The number of "Yes" responses is displayed: