Thinkabara

📗 Excel for Beginners · Lesson 6 of 10

MAX, MIN and COUNT

Google Classroom

The MAX, MIN, COUNT and COUNTBLANK functions in Excel, with a class trip fund example.

The tasks in this lesson

1. Collecting for a trip

  1. B11: =MAX(B2:B9)
  2. B12: =MIN(B2:B9)

💡 MIN ignores empty cells, so it does not return 0.

2. Who has not paid yet?

  1. B13: =COUNT(B2:B9) counts cells that hold a number
  2. B14: =COUNTBLANK(B2:B9) counts empty cells

💡 COUNTA counts every cell that is not empty, including text.

All lessons

  1. ✍️ 1. Typing in cellsCells, typing, fixing and deleting
  2. 🎨 2. Format a tableSelect a range, bold and dollar format
  3. 🧮 3. Your first formulaMultiply, add and subtract between cells
  4. ➕ 4. SUM and AVERAGEThe total and the average of a column
  5. ⬇️ 5. Drag and fillThe fill handle, and $ to lock a cell
  6. 🔢 6. MAX, MIN and COUNTThe most, the least, and how many filled in
  7. 🔀 7. IF: if... then...Pass or fail, and COUNTIF
  8. ↕️ 8. Sort a tableHigh to low, and alphabetical
  9. 📊 9. Your first chartA bar chart and a pie chart
  10. 🏠 10. Project: a family budgetEverything we learned in one sheet