Statistical Functions
Intermediate

MAXIFS: the longest wait in each queue

The worst case for each group rather than overall.

Task:

Your SLA is written per queue. In F2:F3 give the longest wait in minutes for each queue listed in E2:E3.

Interactive Spreadsheet

Read about MIN, MAX

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 MIN, MAX

0/3

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

  1. MAX Function (Statistical)

    The worst case, which is usually what the complaint is about.

    Core
    Beginner
  2. A running maximum: the record so far

    An expanding range turns MAX into "best to date".

    Intermediate
  3. MAXIFS: the longest wait in each queue

    The worst case for each group rather than overall.

    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 × 6 columns2 cells you fill in
ABCDEF
1CallQueueWait (min)QueueLongest wait
2C1Billing4Billing
3C2Technical11Technical
4C3Billing9
5C4Technical7
6C5Billing2
7C6Technical16
8C7Billing6
What this exercise teachesMay contain the answer

The overall MAX is 16, but that only tells you about the Technical queue. A per-group maximum is what an SLA is actually measured against, and putting the queue name in a cell makes adding a third queue a one-row job.