The COUNTIF Function's Syntax
The syntax for the COUNTIF function is:
= COUNTIF ( Range, Criteria )
The COUNTIF Function's Arguments
Range - the group of cells the function is to search.
Criteria - this value is compared with the data in the Range cells. If a match is found then the cell in the Range is counted. Actual data or the cell reference to the data can be entered for this argument.