Formulas and Functions

Chapter 10 Statistical Functions 231
AVERAGE
The AVERAGE function returns the average (arithmetic mean) of a collection of
numbers.
AVERAGE(num-date-dur, num-date-dur…)
 num-date-dur: A value. num-date-dur is a number value, a date/time value, or a
duration value.
 num-date-dur…:Optionally include one or more additional values. If more than
one num-date-dur value is specied, all must be of the same type.
Usage Notes
AVERAGE divides the sum of the numbers by the number of numbers. Â
A string or Boolean value included in a referenced cell is ignored. If you wish to Â
include string and Boolean values in the average, use the AVERAGEA function.
A reference included as an argument to the function can be either to a single cell or Â
to a range of cells.
Examples
=AVERAGE(4, 4, 4, 6, 6, 6) returns 5.
=AVERAGE(2, 2, 2, 2, 3, 3, 3, 3, 4, 4, 4, 4) returns 3.
Related Topics
For related functions and additional information, see:
“AVERAGEA” on page 232
“AVERAGEIF” on page 233
“AVERAGEIFS” on page 234
“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