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.
Using
Using AVERAGEIF
AVERAGEIFS
Excel 2007 included two new conditional calculation functions: AVERAGEIF
and AVERAGEIFS. These functions find the mean of records that match one or
more criteria.
AVERAGEIF oor AVERAGEIFS
Syntax
AVERAGEIF(range,criteria,average_range)
AVERAGEIF returns the arithmetic mean of all the cells in a range that meet
a given criteria.
range
range One or more cells to average, including numbers or names, ar-
rays, or references that contain numbers.
criteria
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
average_range The actual set of cells to average. If omitted, range
is used.
Syntax
AVERAGEIFS(average_range,criteria_range1, criteria1,criteria_range2,cri-
teria2...)
AVERAGEIFS returns the arithmetic mean of all cells that meet multiple cri-
teria.
Search JabSto ::

Custom Search