AVERAGE
The AVERAGE function returns the average (arithmetic mean) of a set of numbers.
To learn the basics about using formulas and functions, see Formulas overview and Functions overview.
AVERAGE(value, value…)
value: A single value or collection. Each value must be a number value, date/time value, or duration value. All values must be of the same value type.
value…: Optionally include one or more additional values or collections of values.
Notes
AVERAGE divides the sum of the numbers by the number of numbers.
A string value 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.
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. =AVERAGE("3d", "6d", "4d", "7d") returns 5d, a duration value. =AVERAGE("12/1/2010", "12/31/2011", "9/30/2013") returns 3/21/12 08:00 AM, a date/time value. |