How to add all the numbers in a column in Excel
![](https://spreadcheaters.com/wp-content/uploads/Final-Image-How-to-add-all-the-numbers-in-a-column-in-excel.png)
Excel offers a very interesting way to add all the numbers in a column. We can cater to this problem statement by using the “SUM()” formula. We can perform the below mentioned way to add all the numbers in a column in excel:
We’ll learn about this methodology step by step.
To do this yourself, please follow the steps described below;
Step 1- Excel workbook with a column with numbers
![](https://spreadcheaters.com/wp-content/uploads/Step-1-How-to-add-all-the-numbers-in-a-column-in-excel.png)
– Open the desired Excel workbook which contains a column populated with some numbers
Step 2 – Entering the formula
![](https://spreadcheaters.com/wp-content/uploads/Step-2-How-to-add-all-the-numbers-in-a-column-in-excel.png)
– Now in any cell type “=”, and then type “SUM(“. Now click on any cell in the column where the numbers are present. (We have selected cell “H2”)
Step 3 – Select the entire column
![](https://spreadcheaters.com/wp-content/uploads/Step-3-How-to-add-all-the-numbers-in-a-column-in-excel.png)
– Now click “CTRL + SPACEBAR”. This will select the entire column as shown in the image above. Now press “Enter”.
Step 4 – Sum obtained
![](https://spreadcheaters.com/wp-content/uploads/Final-Image-How-to-add-all-the-numbers-in-a-column-in-excel.png)
– We can see the sum of the entire column now.