One of the functions of Microsoft Excel is the one that allows you to add numerical values together. You can perform this mathematical operation in several ways, for example by adding the values of some cells or by calculating the sum of the contents of an entire column.
Steps
Method 1 of 3: Adding Values Using a Formula
![Add in Excel Step 1 Add in Excel Step 1](https://i.sundulerparents.com/images/008/image-21735-1-j.webp)
Step 1. Launch Excel
![Add in Excel Step 2 Add in Excel Step 2](https://i.sundulerparents.com/images/008/image-21735-2-j.webp)
Step 2. Click on a cell
![Add in Excel Step 3 Add in Excel Step 3](https://i.sundulerparents.com/images/008/image-21735-3-j.webp)
Step 3. Type the = symbol
![Add in Excel Step 4 Add in Excel Step 4](https://i.sundulerparents.com/images/008/image-21735-4-j.webp)
Step 4. Enter the first value to add
![Add in Excel Step 5 Add in Excel Step 5](https://i.sundulerparents.com/images/008/image-21735-5-j.webp)
Step 5. Type the + sign
![Add in Excel Step 6 Add in Excel Step 6](https://i.sundulerparents.com/images/008/image-21735-6-j.webp)
Step 6. Enter the second value to add
Each number you enter in the formula must be separated from the previous one by the + sign.
![Add in Excel Step 7 Add in Excel Step 7](https://i.sundulerparents.com/images/008/image-21735-7-j.webp)
Step 7. Press the Enter key
This way all the entered values will be added together and the final result will be displayed in the cell of your choice.
Method 2 of 3: Summing Up Using Cell References
![Add in Excel Step 8 Add in Excel Step 8](https://i.sundulerparents.com/images/008/image-21735-8-j.webp)
Step 1. Launch Excel
![Add in Excel Step 9 Add in Excel Step 9](https://i.sundulerparents.com/images/008/image-21735-9-j.webp)
Step 2. Type the first number inside a cell
Make a note of the address of the cell where you entered it (for example "A3").
![Add in Excel Step 10 Add in Excel Step 10](https://i.sundulerparents.com/images/008/image-21735-10-j.webp)
Step 3. Enter a second number inside another cell
You can choose the cell you want, in this case the order doesn't matter.
![Add in Excel Step 11 Add in Excel Step 11](https://i.sundulerparents.com/images/008/image-21735-11-j.webp)
Step 4. Insert the = sign inside a third cell
![Add in Excel Step 12 Add in Excel Step 12](https://i.sundulerparents.com/images/008/image-21735-12-j.webp)
Step 5. Enter the addresses of the cells where you have stored the values to be added by separating them with the = sign
For example, a correct formula might be the following "= A3 + C1".
![Add in Excel Step 13 Add in Excel Step 13](https://i.sundulerparents.com/images/008/image-21735-13-j.webp)
Step 6. Press the Enter key
The result of the sum of the two indicated values should appear in the cell where you entered the formula.
Method 3 of 3: Determine the Sum of a Column
![Add in Excel Step 14 Add in Excel Step 14](https://i.sundulerparents.com/images/008/image-21735-14-j.webp)
Step 1. Launch Excel
![Add in Excel Step 15 Add in Excel Step 15](https://i.sundulerparents.com/images/008/image-21735-15-j.webp)
Step 2. Enter a number in a cell
![Add in Excel Step 16 Add in Excel Step 16](https://i.sundulerparents.com/images/008/image-21735-16-j.webp)
Step 3. Press the Enter key
This way the Excel selection box should move to the cell just below the one where you entered the value.
![Add in Excel Step 17 Add in Excel Step 17](https://i.sundulerparents.com/images/008/image-21735-17-j.webp)
Step 4. Enter the second number to add
You can repeat these steps until you have entered all the values you want to sum into the column of the Excel sheet in question.
![Add in Excel Step 18 Add in Excel Step 18](https://i.sundulerparents.com/images/008/image-21735-18-j.webp)
Step 5. Click on the column header (the cell where the corresponding letter is displayed)
It is displayed at the top of the program window.
![Add in Excel Step 19 Add in Excel Step 19](https://i.sundulerparents.com/images/008/image-21735-19-j.webp)
Step 6. Review the summation of the values in the column
The sum of the numbers of the column in question is displayed on the status bar located at the bottom of the Excel window, on the left of the zoom bar and is indicated by the wording "Sum".