Returns the average of a range depending on criteria.
AVERAGEIF(criteria_range, criterion, [average_range])
Great for averaging specific categories like department scores or product ratings.
Need expert help? →