The COUNTIF function counts the number of values in a range that meet specific criteria. For example it will return how many orders were placed by a specific company or after a specific date.
The syntax for COUNTIF is:
|Range||The range of cells to evaluate.|
|Criteria||The condition that defines which cells are to be counted.|
The example below demonstrates COUNTIF being used to return the number of exams that were passed.