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.

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.
Kasulik?
Tähemärkide piirang: 250
Maksimaalne tähemärkide piirang on 250.
Täname tagasiside eest.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.