One of the features of the various functions available in Microsoft Excel is the ability to add one value to another. You can perform sums in Microsoft Excel in a variety of ways, from summing in the same box to summing the entries in a single column as a whole.
Step
Method 1 of 3: Adding in One Square
Step 1. Open Excel
Step 2. Click the desired box
Step 3. Type the = sign
Step 4. Enter the number you want to add another number to
Step 5. Type the + sign
Step 6. Enter another number
Each number you want to add must be separated by a + sign.
Step 7. Press Enter key
All the numbers you type in will be added up. The result of the sum will be displayed in the same box.
Method 2 of 3: Summing with Square References
Step 1. Open Excel
Step 2. Enter numbers in one box
Write down or remember the number of the box (eg “A3”).
Step 3. Type a number into another box
The order of the boxes will have no effect.
Step 4. Type = into the third box
Step 5. Enter the numbers of the boxes containing the entries after the = sign
For example, you could type "=A3+C1".
Step 6. Press Enter
You can see the result of the sum in the last box (the box containing the addition formula)!
Method 3 of 3: Determining the Number of Values in One Column
Step 1. Open Excel
Step 2. Enter numbers in one box
Step 3. Press Enter key
After that, the selection box will be moved to the box or row below it.
Step 4. Type in another number
You can repeat this process for each number you want to add up.
Step 5. Click the column letter
Column letters are at the top of the screen.
Step 6. View the number of column values
You can see the sum of the numbers or “Sum” on the left side of the zoom bar, in the lower right corner of the Excel window.
