AVERAGEIF: average only what matters

Average only the rows that match a rule.

It's exactly like SUMIF, except instead of adding, it calculates the average:

Module: Counting and adding with rules. Lesson 19 of 62.