COUNTIF function

description:

Counts cells that match the specified criteria.

 

syntax:

=COUNTIF( rangecriteria )

 

required arguments:

range The range of cell to check.
criteria The condition that controls which cell will be displayed.