AVERAGEIF function
Summary
Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria
Syntax
AVERAGEIF(range, criteria, [average_range])
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. For example, criteria can be expressed as 32, "32", ">32", "apples", or B4.
• Average_range Optional. The actual set of cells to average. If omitted, range is used.
• 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. For example, criteria can be expressed as 32, "32", ">32", "apples", or B4.
• Average_range Optional. The actual set of cells to average. If omitted, range is used.
Example
=AVERAGEIF(B2:B5,"<23000")
=AVERAGEIF(A2:A5,"<250000")
=AVERAGEIF(A2:A5,"<95000")
=AVERAGEIF(A2:A5,">250000",B2:B5)
=AVERAGEIF(A2:A6,"=*West",B2:B6)
=AVERAGEIF(A2:A6,"<>*(New Office)",B2:B6)
=AVERAGEIF(A2:A5,"<250000")
=AVERAGEIF(A2:A5,"<95000")
=AVERAGEIF(A2:A5,">250000",B2:B5)
=AVERAGEIF(A2:A6,"=*West",B2:B6)
=AVERAGEIF(A2:A6,"<>*(New Office)",B2:B6)