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:
=COUNTIF(range, criteria)
Argument | Purpose |
---|---|
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.