COUNTIF
Spread WinRT Documentation > Formula Reference > Formula Functions > COUNTIF

Summary

This function returns the number of cells that meet a certain condition.

Syntax

COUNTIF(cellrange,condition)

Arguments

This function has these arguments:

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

Data Types

Accepts cell range reference. Returns numeric data.

Examples

COUNTIF(A1:G5,"test")

COUNTIF(R6C3:R9C4,"<2")

See Also