Microsoft Office Tutorials and References
In Depth Information
Using AVERAGEIF or AVERAGEIFS
The HARMEAN function returns the harmonic mean of a data set. The har-
monic mean is the reciprocal of the arithmetic mean of reciprocals. The ar-
guments number1, number2, ... are one to 255 arguments for which you want to
calculate the mean. You can also use a single array or a reference to an ar-
ray instead of arguments separated by commas.
The arguments must be either numbers or names, arrays, or references that
contain numbers. If an array or a reference argument contains text, logical
values, or empty cells, those values are ignored; however, cells that con-
tain the value 0 are included. If any data point is less than or equal to 0,
HARMEAN returns a #NUM! error. The harmonic mean is always less than
the geometric mean, which is always less than the arithmetic mean.
Excel 2007 included two new conditional calculation functions: AVERAGEIF
and AVERAGEIFS. These functions find the mean of records that match one or
AVERAGEIF oor AVERAGEIFS
AVERAGEIF returns the arithmetic mean of all the cells in a range that meet
a given criteria.
range — One or more cells to average, including numbers or names, ar-
rays, or references that contain numbers.
criteria — The criteria in the form of a number, expression, cell ref-
erence, or text that defines which cells are averaged. For example,
criteria can be expressed as 32, "32", ">32", "apples", or B4.
average_range — The actual set of cells to average. If omitted, range
AVERAGEIFS returns the arithmetic mean of all cells that meet multiple cri-