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