ExcelHeroThe SUM function
Adds up numbers, cells and ranges.
In German Excel: SUMME
How to write it
=SUM(number1, [number2], …)- number1
- A number, cell or range like B2:B6.
- number2
- Optional. More numbers or ranges.
💡 Text and empty cells in the range are skipped.
Try it
How many coffees were sold this week? Add up B2 to B6.
A
B
1
Day
Coffees
2
Mon
42
3
Tue
38
4
Wed
51
5
Thu
47
6
Fri
66
7
Total
Start with =SUM( and select the five numbers.