ANALYSIS

COUNTIF & COUNTIFS

Count rows that meet one or several conditions.

After this lessonBuild quick exception and category counts.

How it works

COUNTIF counts cells that meet one criterion. COUNTIFS extends the idea to multiple range/criteria pairs and counts only rows where every condition is true.

Criteria can be exact text, wildcard patterns or comparison strings such as ">100".

REAL WORK

Count missing scans, orders for a supplier or records with both a specific status and material family.

SYNTAX

The pattern

=COUNTIF(range, criteria)
=COUNTIFS(range1, criteria1, range2, criteria2)

Example

=COUNTIF(D2:D6,"Alpha")

TRY IT

Test the formula

The sample sheet is local to this page. Change the formula and see the result immediately.

Result

QUICK CHECK

Which function handles multiple conditions?

Progress is stored only in this browser. No account required.