beautypg.com

Averageifs, 234 averageifs – Apple iWork '09 User Manual

Page 234

background image

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