COUNTIFS

StatisticalExcel 2007

Count cells meeting several conditions.

Syntax

COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], …)

Examples

=COUNTIFS(status, "Open", owner, A2)

→

Related functions

COUNTIF SUMIFS

More Statistical functions

AVEDEV AVERAGE AVERAGEA AVERAGEIF AVERAGEIFS BETA.DIST BETA.INV BINOM.DIST BINOM.DIST.RANGE BINOM.INV CHISQ.DIST CHISQ.DIST.RT

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.