About this lesson
MIN, MAX and simple stats
=MAX(B2:B13) returns the largest number in a range and =MIN(B2:B13) the smallest. =COUNT(B2:B13) counts the cells that hold numbers. All three skip text such as "n/a" and empty cells.
=SUM(B2:B13)What you'll practise
Review Wattle Pharmacy Group's Queensland stores for the strategy team: total revenue with AutoSum, best and worst store with MAX and MIN, and COUNT to see how many stores each figure covers.
4 steps · 40 points · the cells outlined in gold below
- MAX
- MIN
- COUNT
- AutoSum
- fill right
The data
| A | B | C | |
|---|---|---|---|
| 1 | Store | Revenue ($m) | EBITDA margin |
| 2 | Toowoomba | 14.8 | 11.8% |
| 3 | Cairns Central | 12.6 | 10.4% |
| 4 | Townsville | 11.9 | 9.7% |
| 5 | Chermside | 18.4 | 14.2% |
| 6 | Indooroopilly | 16.2 | 13.1% |
| 7 | Southport | 13.7 | 10.9% |
| 8 | Robina | 10.9 | 8.8% |
| 9 | Mackay | 8.3 | 7.6% |
| 10 | Rockhampton | 7.6 | 7.1% |
| 11 | North Lakes (opened FY26) | 9.4 | n/a |
| 12 | Springfield (opened FY26) | 5.2 | n/a |
| 13 | Maroochydore | 12.1 | 11.3% |
| 14 | Total | ||
| 15 | |||
| 16 | Highest | ||
| 17 | Lowest | ||
| 18 | Stores counted |