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.