Lesson · Beginner · 25 min
Lookups and conditional sums
XLOOKUP for fetching one value, SUMIFS and COUNTIFS for totals by condition.
- spreadsheets
- lesson
Inside this lesson
- You will: Write an XLOOKUP with a not-found value
- You will: Write SUMIFS with multiple criteria
- Sections
- 3
- Exercise
- Yes
The full lesson opens with a membership that covers Excel Skills.
Sign in if you already subscribe.
Sign in