AVERAGEIFS function calculates the average value of cells in a range that meet multiple criteria.
This function calculates the average value in the Salary range if the Title range contains Account Rep and if the Location range contains Atlanta.
=AVERAGEIFS(E$2:E$13,C$2:C$13,"Account Rep",B$2:B$13,"Atlanta")
=AVERAGEIFS(average_range,criteria_range1,criteria1,criteria_range2, criteria2...)
No comments:
Post a Comment