Statistical Functions
Intermediate

Count values between two limits

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

Task:

Deliveries promised "in 3 to 5 days" were on time if they took from 3 to 5 days inclusive. In B10 count how many of these eight landed inside that window.

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.

    Core
    Intermediate
  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.

10 rows × 2 columns1 cell you fill in
AB
1DeliveryDays
2D-012
3D-023
4D-036
5D-045
6D-054
7D-067
8D-073
9D-081
10Inside 3–5 days
What this exercise teachesMay contain the answer

"Between" is two conditions joined by AND, and COUNTIFS is COUNTIF with AND built in. Repeating the range is not a mistake — it is how you put two limits on one column. Both ends are inclusive here, so 3 and 5 count.