The COUNTIF Function's Syntax
In Excel, a function's syntax refers to the layout of the function and includes the function's name, brackets, and arguments.
The syntax for the COUNTIF function is:
= COUNTIF ( Range, Criteria )
The COUNTIF Function's Arguments
The function's arguments tell the function what condition we are testing for and what range of data to count when the condition is met.
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.
