Spread 8.0 Documentation
COUNTIF
Support Options
Formula Reference > Built-In Functions > COUNTIF

Glossary Item Box

COUNTIF


Name

Countif

Description

Returns the number of cells that meet a certain condition.

Syntax

COUNTIF(cellrange,condition

This function has the following arguments:

Argument Description
cellrange Range of cells to count; cell range reference
condition Condition that determines which cells are counted, as text, number, or expression

Data Type

Accepts cell range references. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

COUNTIF(A1:G5,"test")
COUNTIF(R6C3:R9C4,"<2")

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.