Average with a condition

AVERAGEIF works like SUMIF, but gives the average of the matching rows.

3 exercises in this lesson are part of ExcelHero Pro.