Formula guides
Excel formulas, explained and practiced.
Short, plain-English guides to the formulas people actually use at work. Each one ends with a live spreadsheet, so you can try the formula before you close the tab.
- Guides
- 5
- Functions covered
- 10
- Live exercises
- 100
How to Use COUNTIF in Excel (and COUNTIFS)
Count cells that match a rule with COUNTIF. Text, numbers, dates, blanks, partial matches and duplicates, plus COUNTIFS for more than one condition.
Read the guide →
- ∑ifConditional math·4 minNew
How to Use COUNTIF in Excel (and COUNTIFS)
Count cells that match a rule with COUNTIF. Text, numbers, dates, blanks, partial matches and duplicates, plus COUNTIFS for more than one condition.
COUNTIFCOUNTIFS→ - ?:Logic·4 min
How to Use the IF Function in Excel
Learn the Excel IF function step by step. Comparisons, text results, IF with AND and OR, nested IFs and IFS, plus the mistakes that cause errors.
IFANDOR→ - ⇄Lookups·4 min
How to Use VLOOKUP in Excel, Step by Step
VLOOKUP explained in plain English. How the four arguments work, why you should almost always use FALSE, how to fix #N/A, and when to switch to XLOOKUP.
VLOOKUP→ - ⇄Lookups·5 min
How to Use XLOOKUP in Excel
Learn how XLOOKUP works with simple examples. Find a value, look to the left, return several columns, handle missing values and search from the bottom.
XLOOKUP→ - ∑ifConditional math·4 min
SUMIF and SUMIFS in Excel, Explained
How to use SUMIF and SUMIFS to total only the rows that match. Text, numbers, dates, wildcards and several conditions, and why the argument order differs.
SUMIFSUMIFS→
Practice makes formulas
Stop reading. Start typing formulas.
Every exercise is a real spreadsheet with instant feedback. The first two in every topic are free, no sign-up needed.