AVERAGEIF function calculates the average, or arithmetic mean, of all cells in a range that meet a specific condition.
=AVERAGEIF(C2:C13,"Account Rep", E2:E13)
=AVERAGEIF(range, criteria, average_range)
Range and Criteria meanings are the same as SUMIF. The average_range argument specifies the range containing values that you want to average if the condition is met.
No comments:
Post a Comment