Apple iWork Numbers Function Reference

COUNTIF

Description

The COUNTIF function counts the cells in a range that satisfy a specified condition.

Syntax

COUNTIF(test-range, condition)

• test-range: The range of cells to be tested.
• condition: The conditional test that results in a logical TRUE or FALSE.

Note: For more information on the comparison operators you can use in the conditional test, see “Understanding the Comparison Operators” on page 93.

Examples