Stage 2 · Lesson 2 of 6
SUMIFS, COUNTIFS and IF logic
, COUNTIFS and AVERAGEIFS add up, count or average only the rows that meet your conditions. For example: revenue for the North region in March. Use IF, AND and OR alongside them to label rows.
Together these answer most quick without a . They are the spreadsheet version of filtering and grouping in (WHERE plus GROUP BY), which you meet in the next stage. Try building a small summary grid: regions down the side, months across the top, and a SUMIFS in each cell.
Common traptext that looks like it matches but does not, such as "North " with a trailing space or a number stored as text, so a condition silently skips rows and your total comes out short.
A question to check yourself, an AI practice session and 1 cheat sheet entry come with the full roadmap. Unlock
Resources for this stage
Start with
- GuideFreeExcel help and learning
Microsoft · Beginner
Official, accurate guides to XLOOKUP, SUMIFS, PivotTables and cleaning functions, with examples you can paste