IntermediateData Analysis
Total only the orders above average
Sum the orders that beat the average, without typing the average in yourself.
SUMIF · AVERAGE
8 min25 points
Count staff overdue a review
The situation
Harbor Supply's policy is a review every twelve months. HR needs to know how many people in Operations have gone at least that long, so the department head can be given a number rather than a vague sense that it has slipped.
A1
fx
| Row number | A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|---|
| 1 | Employee | Department | Months | ||||
| 2 | Dana Whitfield | Operations | 14.00 | Operations overdue | |||
| 3 | Marcus Bell | Sales | 18.00 | ||||
| 4 | Priya Raman | Finance | 6.00 | ||||
| 5 | Tom Alvarez | Operations | 9.00 | ||||
| 6 | Sara Kim | Sales | 13.00 | ||||
| 7 | Luis Ortega | Operations | 20.00 | ||||
| 8 | Amy Chen | Finance | 11.00 | ||||
| 9 | Jon Pike | Sales | 3.00 | ||||
| 10 | Rita Moss | Operations | 12.00 | ||||
| 11 | Neil Barr | Marketing | 15.00 | ||||
| 12 |
Functions in this exercise
- COUNTIFS — Counts cells that meet several conditions at once. Syntax and example
Who this is for
Recommended next
Related exercises
- IntermediateData Analysis
Count backorders on three conditions
Narrow a count with three criteria at once rather than filtering by hand.
COUNTIFS
8 min25 points - IntermediateData Analysis
Count orders inside a value band
Apply an upper and a lower bound to the same column at once.
COUNTIFS
7 min25 points - IntermediateStatistical Functions
Count orders meeting two conditions
Count rows that satisfy several criteria at once.
COUNTIFS
8 min25 points