Lookup & Conditional Sums
XLOOKUP, VLOOKUP, INDEX MATCH, SUMIFS and COUNTIFS: why lookups fail and how to sum or count with conditions.
4 tutorialsBrowse by topic
Every tutorial belongs to one topic hub. Start with the hub's guide, then work through the related fixes.
Sheets Errors & Dynamic Arrays
IMPORTRANGE, QUERY parse errors, "array result was not expanded", #SPILL!, FILTER and ARRAYFORMULA explained.
6 tutorialsDates & Times
Sum hours over 24, overnight shifts, ages, working days and dates stored as text, in Excel and Google Sheets.
4 tutorialsData Cleaning & Entry
Duplicates, stray spaces, numbers stored as text, splitting names, extracting emails and drop-down lists.
5 tutorialsTemplates & Trackers
Checkbox counters, habit trackers, invoices, attendance, inventory and Gantt charts you can copy and adapt.
1 tutorial