AVERAGEIF
Returns the average of all the cells in a range that meet a given criteria
Syntax
AVERAGEIF(range, criteria, [average_range])
Parameters
- range: Required. The range of cells to average
- criteria: Required. The criteria that defines which cells are averaged
- average_range: Optional. The actual set of cells to average. If omitted, range is used
Example
=AVERAGEIF(B2:B5, ">250000")