COUNTIF Formula

COUNTIF formula counts the number of cells in a range, that meets a given criteria. it works with single criteria only. For multiple criterias 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.

Returns

The COUNTIF function returns a numeric value.

COUNTIF Formula Example
COUNTIF Formula Example