Statistical FunctionsIntermediate

COUNTIF Function

Counting only the rows that broke a rule.

Task:

You promise delivery within 4 days. Put the number of these six deliveries that took longer than that in B8.

Interactive Spreadsheet

Read about COUNTIF

Hints

+5 XPno-hints bonus

Solve it on your own to keep the bonus. Each hint gets one step closer to the formula.

Variations of COUNTIF

0/3

The same formula in the other shapes it takes at work.

  1. COUNTIF Function

    Counting only the rows that broke a rule.

    CoreIntermediate
  2. Count values between two limits

    COUNTIFS on the same column twice: at least this, at most that.

    Intermediate
  3. COUNTIF with the threshold in a cell

    Join the operator to a cell with & so the limit can change.

    Intermediate

The data in this exercise

This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.

8 rows × 2 columns1 cell you fill in
AB
1DeliveryDays taken
2D-22012
3D-22025
4D-22033
5D-22047
6D-22054
7D-22066
8Missed the 4-day promise

Functions used here

What this exercise teachesMay contain the answer

The boundary is the whole exercise. ">4" counts the 5, 6 and 7-day deliveries; ">=4" would sweep in the one that arrived exactly on the promise and turn a clean record into a breach. Quoting the wrong one of those to a customer is how a report loses its credibility.