COUNTIF function

Category: Statistical functions

What does this function do?

Count the cells in a range that meet a specified condition.

Syntax:

COUNTIF(range, criteria)

• range (required): One or more cells to count, including numbers or names, arrays, or references that contain numbers. Blank and text values are ignored.

• criteria (required): A number, expression, cell reference, or text string that defines which cells will be counted. For example, criteria can be expressed as 32, ">32", B4, "apples", or "32".

Examples:

=COUNTIF(A1:A3,"> 1") = 2 if A1:A3 = {1,2,3}
=COUNTIF(B1:B3,"count") = 1 if B1:B3 = {"add", "count", "add"}