Returns the average of a range of numbers that meet a given criteria.
AVERAGEIF([First Results]1:Data25, >25)
- range—The range of cells to evaluate for the specified condition.
- criterion—The condition that defines which numbers to add (for example: 15, “Hello World!”, >25).
- average_range—[optional]The range of cells to average.