Formulas and Functions

Related Topics
For related functions and additional information, see:
“AVERAGE” on page 231
“AVERAGEA” on page 232
“AVERAGEIFS” on page 234
“Specifying Conditions and Using Wildcards” on page 360
“Listing of Statistical Functions” on page 225
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
AVERAGEIFS
The AVERAGEIFS function returns the average (arithmetic mean) of the cells in a given
range where one or more ranges meet one or more related conditions.
AVERAGEIFS(avg-values, test-values, condition, test-values…, condition…)
 avg-values: A collection containing the values to be averaged. avg-values is a
reference to a single range of cells or an array, which may contain only numbers,
numeric expressions, or Boolean values.
 test-values: A collection containing values to be tested. test-values is a collection
containing any type of value.
 condition: An expression that results in a logical TRUE or FALSE. condition is an
expression that can contain anything as long as the result from comparing condition
to a value in test-values can be expressed as a Boolean value of TRUE or FALSE.
 test-values…:Optionally include one or more additional collections containing
values to be tested. Each test-values collection must be followed immediately with a
condition expression. This pattern of test-values, condition can be repeated as many
times as needed.
 condition…:If an optional collection of test-values is included, an expression that
results in a logical TRUE or FALSE. There must be one condition following each
test-values collection; therefore, this function will always have an odd number of
arguments.
234 Chapter 10 Statistical Functions