Content

• Steps
• Method 1 of 3: Adding inside a cell
• Method 2 of 3: Add values ​​from different cells
• Method 3 of 3: Determining the Column Sum
• Tips
• Warnings

One of the many features in Microsoft Excel is the ability to sum the sum of multiple values. In Microsoft Excel, values ​​can be added in several ways, from counting the amount in one cell to counting the amount in an entire column.

Steps

Method 1 of 3: Adding inside a cell

1. 1 Start Excel.
2. 2 Click on the cell.
3. 3 Enter sign =.
4. 4 Enter the number you want to add to the other.
5. 5 Enter sign +.
6. 6 Please enter a different number. Each subsequent number must be separated by a sign +.
7. 7 Click on ↵ Enterto add all the numbers in the cell. The end result will be displayed in the same cell.

Method 2 of 3: Add values ​​from different cells

1. 1 Start Excel.
2. 2 Enter a number in the cell. Remember its location (for example, A3).
3. 3 Enter the second number in another cell. The order of the cells does not matter.
4. 4 Enter sign = into the third cell.
5. 5 Enter the location of the cells with numbers after the sign =. For example, a cell may contain the following formula: = A3 + C1.
6. 6 Click on ↵ Enter. The sum of the numbers will be shown in the cell with the formula!

Method 3 of 3: Determining the Column Sum

1. 1 Start Excel.
2. 2 Enter a number in the cell.
3. 3 Click on ↵ Enterto move down one cell.
4. 4 Enter another number. Repeat as many times as the numbers need to be added.
5. 5 Click on the letter of the column at the top of the window.
6. 6 Find the sum of the column. The "SUM" value is displayed to the left of the zoom bar in the lower right corner of the page.
   • Instead, you can hold down the key Ctrl and click on each cell. The "SUM" value will display the sum of the selected cells.

Tips

• Copy and paste data from other Microsoft Office programs (for example, from Word) into Excel to quickly calculate the sum of values.

Warnings

• Excel mobile might not have a function to calculate the sum of a column.