Navigation:  Formula Reference > Spreadsheet Formula Functions >

COUNTIFS

Previous pageReturn to chapter overviewNext page

 

This function returns the number of cells that meet multiple conditions.

Syntax

COUNTIFS(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

COUNTIFS(A1:G5,"test",B3:D3,"=Yes")

COUNTIFS(R6C3:R9C4,"<2")

 

See Also

COUNT

COUNTA

COUNTBLANK

SUMIF