BeginnerStatistical Functions
Find the average order value with AVERAGE
Calculate the mean value of a set of customer orders.
AVERAGE
3 min10 points
Count the headcount in one department
The situation
Harbor Supply's HR coordinator is asked for the Operations headcount before a budget meeting. The staff list is one row per employee with no totals anywhere, and counting down the column by eye is how the last figure came out wrong.
A1
fx
| Row number | A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|---|
| 1 | Employee | Department | Tenure | ||||
| 2 | Dana Whitfield | Operations | 4.5 | Operations headcount | |||
| 3 | Marcus Bell | Sales | 2.0 | ||||
| 4 | Priya Raman | Finance | 6.5 | ||||
| 5 | Tom Alvarez | Operations | 1.5 | ||||
| 6 | Sara Kim | Sales | 3.0 | ||||
| 7 | Luis Ortega | Operations | 8.0 | ||||
| 8 | Amy Chen | Finance | 2.5 | ||||
| 9 | Jon Pike | Sales | 0.5 | ||||
| 10 | Rita Moss | Operations | 5.5 | ||||
| 11 | Neil Barr | Marketing | 3.5 | ||||
| 12 |
Functions in this exercise
- COUNTIF — Counts cells that meet one condition. Syntax and example
Who this is for
Recommended next
Related exercises
- BeginnerStatistical Functions
Count how many orders shipped with COUNT
Use COUNT to find how many rows contain a numeric value.
COUNT
4 min10 points - BeginnerStatistical Functions
Count orders above a threshold with COUNTIF
Count how many rows meet a numeric condition.
COUNTIF
5 min15 points - IntermediateData Cleaning
Spot duplicate order numbers with COUNTIF
Find rows whose order number appears more than once in the column.
COUNTIF · IF
9 min30 points