ExcelHero

The AVERAGE function

Returns the average (arithmetic mean) of numbers.

In German Excel: MITTELWERT

How to write it

=AVERAGE(number1, [number2], …)
number1
A number, cell or range.

💡 Empty cells are ignored, but cells with 0 count.

Try it

What is the class average?

A
B
1
Student
Score
2
Aisha
88
3
Ben
54
4
Chloe
97
5
Dev
71
6
Emma
63
7
Finn
79
8
Average

=AVERAGE( and select all six scores.