AVERAGEIF function

description:

Return the average (arithmetic mean) of its arguments specified by a given criteria.

 

syntax:

=AVERAGEIF( rangecriteria[average_range] )

 

required arguments:

range The range of cells that you want to apply the criteria against.
criteria The criteria used to determine for which numbers calculate the average.

 

optional arguments:

[average_range] The cells to average. When omitted, the range is used.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.