Pro lesson · 7 exercises · first one free
Pick by number and total filtered lists: CHOOSE and SUBTOTAL
About this lesson
Return the nth item from a short list, and add up only the rows a filter leaves visible.
Lookups · 7 short exercises in a live spreadsheet: you type each formula yourself and answer questions that make you predict results or spot bugs. Every answer is checked instantly.
What you'll practise
- Choosing a label by position number
- Picking a weekday name from its number
- Totalling a list with SUBTOTAL
- Knowing why a total ignores a filter
- Finding the largest visible value
- Using CHOOSE inside a calculation
- Choosing a position that does not exist
Functions you'll use
Try the first exercise free
Type the formula in a real spreadsheet and get instant feedback. Exercise 1 of 7, no account needed.
Pro lesson
Unlock the whole lesson
Pro unlocks every lesson, the case studies and unlimited weak-spot review. The fundamentals track stays free.