🟡 Intermediate 12 minintermediate path
SUMIF, COUNTIF, AVERAGEIF
Conditional aggregates — the fastest way to slice numbers without a Pivot Table.
Learning objectives
- Total, count, and average subsets of data using a single criterion.
Step-by-step
1. SUMIF
=SUMIF(range, criterion, sum_range). Example: =SUMIF(B:B,"West",D:D) totals sales where region is West.
2. COUNTIF
=COUNTIF(B:B,"West") counts West rows. Wildcards: "*inc*" matches any text containing "inc".
3. AVERAGEIF
=AVERAGEIF(B:B,"West",D:D) averages amount for West only.
4. Multiple criteria
When you need more than one criterion, jump to SUMIFS, COUNTIFS, AVERAGEIFS — same idea, criterion pairs.
Key takeaways
- Total, count, and average subsets of data using a single criterion.
Related lessons
Excel Basics: The Ribbon, Cells, and Saving
12 min • Beginner
Your First Formulas: SUM, AVERAGE, and Basic Math
15 min • Easy
Lookups: VLOOKUP and XLOOKUP Explained
20 min • Intermediate
Pivot Tables in Under 20 Minutes
20 min • Advanced