Returns the average of all the cells in a range that meet a given criteria.
Special Offer for First Time Users
If you are the first time user and want to learn Microsoft office skills, then you can avail this special offer discount on your email.
The AVERAGEIF function syntax has the following arguments:
Range:- Required. One or more cells to average, including numbers or names, arrays, or references that contain numbers.
Criteria:- Required. The criteria in the form of a number, expression, cell reference, or text that defines which cells are averaged.
Average_range:- Optional. The actual set of cells to average. If omitted, range is used.