COUNTIF(r, c)

Where 'r' is the range of cells.
'c' is the criteria in the form of a number, expression, cell reference, or text.
COUNTIF() function calculates the number of cells that satisfy a given criteria.

Description

COUNTIF(r, c)

For example, COUNTIF(A1:A8,"JOHN") returns the number of cells in the range A1 through A8 and which matches with the text "JOHN".

Criteria containing numbers can be expressed as 66, "66","<=66", ">=66", "<>66" etc.

Combination of functions can also be used as COUNTIF(A1:A3,"Red")+COUNTIF(A4:A7,"Orange") etc.

Wild card characters such as '*', '?', '~' can be used in the criteria field to match a certain sequence of characters.

COUNT() can be used to count the number of cells in the given range except logical values, error values and text.

COUNTA() can be used to count the number of non-empty cells that may be numbers, number representation of a text, error or logic values, dates etc.

Syntax

Examples

Description

Lets see an example,

COUNTIF(R,C)

B C

'

P 50

Q 65

R 90

P 151

=COUNTIF(B2:B5,"P") is 2

=COUNTIF(C2:C5,">66") is 2