Roadmap
Day 8 · Formulas 40 min 30 XP
➕SUM, AVERAGE, COUNT, MIN & MAX
Five functions answer most first questions about a column of numbers: how much, how typical, how many, how low, how high.
What you'll learn
- Use SUM, AVERAGE, COUNT, MIN and MAX on a range
- Tell COUNT from COUNTA
- Lock a cell with $ when copying formulas
A peek inside
The core five
The rest of Day 8 is a Pro lesson
You're on the free Explorer plan — you get the intro and the video. Go Pro to open the full guided lesson (and all 30 days).
- 3 deep-dive lessons
- A copy-paste worked example
- 3 hands-on practice tasks
- Studio task: Summary strip for a column
- 3-question quiz, up to 45 XP
- 3 quick-glance glossary cards
- 30 XP + streak tracking
Already Pro? Sign in