Home › Functions › Statistical › AVERAGEA
fx
AVERAGEA
Statistical  ·  Since: Excel 2003  ·  9 languages

Calculates the average (arithmetic mean) of the values in the list of arguments.

🌐 Translations

English AVERAGEA
Deutsch MITTELWERTA
Français AVERAGEA
Español PROMEDIOA
Italiano MEDIA.VALORI
Português MÉDIAA
Nederlands GEMIDDELDEA
Polski ŚREDNIA.A
Русский СРЗНАЧА

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

AVERAGEA(value1,[value2],...)

Arguments

value1 (required)
value2 (optional)

▶ Examples

=AVERAGEA(A2:A6)
=AVERAGEA(A2:A5,A7)

Related functions

Copied to clipboard