Lesson 6: MAX, MIN and COUNT
- B11:
=MAX(B2:B9) - B12:
=MIN(B2:B9)
| A | B | |
|---|---|---|
| 1 | Name | Paid ($) |
| 2 | Daniel | 50 |
| 3 | Tammy | |
| 4 | Ryan | 50 |
| 5 | Leah | 30 |
| 6 | Nate | |
| 7 | Hannah | 50 |
| 8 | Ron | 20 |
| 9 | Addie | 50 |
| 10 | ||
| 11 | Highest | |
| 12 | Lowest | |
| 13 | How many paid | |
| 14 | How many have not paid |
- B11 = 50, using MAX
- B12 = 20, using MIN
All lessons
✍️ 1. Typing in cells
Cells, typing, fixing and deleting🎨 2. Format a table
Select a range, bold and dollar format🧮 3. Your first formula
Multiply, add and subtract between cells➕ 4. SUM and AVERAGE
The total and the average of a column⬇️ 5. Drag and fill
The fill handle, and $ to lock a cell🔢 6. MAX, MIN and COUNT
The most, the least, and how many filled in🔀 7. IF: if... then...
Pass or fail, and COUNTIF↕️ 8. Sort a table
High to low, and alphabetical📊 9. Your first chart
A bar chart and a pie chart🏠 10. Project: a family budget
Everything we learned in one sheet
Cells, typing, fixing and deleting🎨 2. Format a table
Select a range, bold and dollar format🧮 3. Your first formula
Multiply, add and subtract between cells➕ 4. SUM and AVERAGE
The total and the average of a column⬇️ 5. Drag and fill
The fill handle, and $ to lock a cell🔢 6. MAX, MIN and COUNT
The most, the least, and how many filled in🔀 7. IF: if... then...
Pass or fail, and COUNTIF↕️ 8. Sort a table
High to low, and alphabetical📊 9. Your first chart
A bar chart and a pie chart🏠 10. Project: a family budget
Everything we learned in one sheet
The MAX, MIN, COUNT and COUNTBLANK functions in Excel, with a class trip fund example. MIN ignores empty cells, so it does not return 0. COUNTA counts every cell that is not empty, including text.
Explore more: Excel course: all lessons, and IF: if... then....