Excel formula translator
Translator
Functions
Translation table
Error codes
Academy
🔍
Search functions
🌐 EN ▾
English
Deutsch
Français
Español
Português
☰
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 version
Available
Excel 2007
✓
Excel 2013
✓
Excel 2019
✓
Excel 2021
✓
Microsoft 365
✓
Translate a formula with this function
fx
EN
=AVERAGEA(A2:A6)
fx
DE
⌨
Syntax
AVERAGEA(value1,[value2],...)
Arguments
value1
(required)
value2
(optional)
▶
Examples
=AVERAGEA(A2:A6)
=AVERAGEA(A2:A5,A7)
Related functions
AVEDEV
AVERAGE
AVERAGEIF
AVERAGEIFS
BETA.DIST
BETA.INV
BINOM.DIST
BINOM.DIST.RANGE
Copied to clipboard
↑
↓
·
Enter
·
Esc
Excel functions ›