Goal: Find the average Score for specific groups. AVERAGEIF: One condition. AVERAGEIFS: Multiple conditions.
SUM
0
÷
COUNT
0
=
AVG
-
Ready...
💻 Formula Structure
=AVERAGEIF(range, criteria, [avg_range])
1. Range: Where to check (e.g., Classes).
2. Criteria: What to look for ("Math").
3. Avg Range: Numbers to average (Scores).
=AVERAGEIFS(avg_range, crit_rng1, crit1, ...)
1. Avg Range: Numbers to average. (First!)
2. Range 1: First check (Classes).
3. Crit 1: "Math".
-- Select a scenario...
...
Result:
-
⚠️ Common Pitfalls
🚫 Zero vs Blank
If a student was absent (Blank), they are ignored.
If they got a 0 (Zero), they drag the average down.
AVERAGEIF treats them correctly based on cell content.
🚫 Argument Swap
Just like SUMIFs, AVERAGEIFS puts the numeric range first. AVERAGEIF puts it last.