← All exercises

COUNTIF discovery — Customer file

COUNTIF discovery — Client file

Count how many clients match a single condition (status, children, email) in a client file using COUNTIF — 6 guided steps, no fill-down.

=COUNTIF( range , "criteria" )

1 / 6

Count the married clients

=COUNTIF( range , criteria_cell )

2 / 6

Count using a cell reference

=COUNTIF( range , value )

3 / 6

Count by numeric value

=COUNTIF( range , value )

4 / 6

Count the zeros

=COUNTIF( range , "" )

5 / 6

Count the empty cells

=COUNTIF( range , criteria_cell )

6 / 6

Count using a cell reference (2)

Your score is

0%