Adding up all values in a column in Excel

To add up all the values from one Excel column in one cell, we only need to do this :

• click on the cell
• Write =SUM(COLUMN:COLUMN)

E.g. in following example it is =SUM(B:B), because my numbers are in column B.