COUNTIF formula counts the number of cells in a range, which meets a given criteria. it works with single criteria only. For multiple criteria COUNTIFS formula can be used.

Syntax of COUNTIF  formula:

COUNTIF( range, criteria )

Parameters Details

range : The range of cells that you want to count based on the criteria.
criteria : The criteria used to determine which cells to count.


The COUNTIF function returns a numeric value.

COUNTIF Formula Example
COUNTIF Formula Example