AVERAGEIF
Definition: AVERAGEIF is a function that returns the average of a range of cells that meet a specified criterion. Syntax: =AVERAGEIF(range, criteria, [average_range]) Situation: This formula is suitable...