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
Step 1. Launch Excel
Step 2. Click on a cell
Step 3. Type the = symbol
Step 4. Enter the first value to add
Step 5. Type the + sign
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.
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
Step 1. Launch Excel
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").
Step 3. Enter a second number inside another cell
You can choose the cell you want, in this case the order doesn't matter.
Step 4. Insert the = sign inside a third cell
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".
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
Step 1. Launch Excel
Step 2. Enter a number in a cell
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.
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.
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.
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".