Formulas and Functions
Modifying this control will update this page automatically

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("1/12/2010", "31/12/2011", "30/9/2013") returns 21/3/12 08:00 am, a date/time value.

See alsoAVERAGEAAVERAGEIFAVERAGEIFSAdd and edit formulasReview formula errors and follow best practicesRefer to cells in formulas
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.