3 Ways to Sum in Excel

Table of contents:

3 Ways to Sum in Excel
3 Ways to Sum in Excel
Anonim

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

Step 1. Launch Excel

Add in Excel Step 2
Add in Excel Step 2

Step 2. Click on a cell

Add in Excel Step 3
Add in Excel Step 3

Step 3. Type the = symbol

Add in Excel Step 4
Add in Excel Step 4

Step 4. Enter the first value to add

Add in Excel Step 5
Add in Excel Step 5

Step 5. Type the + sign

Add in Excel Step 6
Add in Excel Step 6

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

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

Step 1. Launch Excel

Add in Excel Step 9
Add in Excel Step 9

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

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

Step 4. Insert the = sign inside a third cell

Add in Excel Step 12
Add in Excel Step 12

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

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

Step 1. Launch Excel

Add in Excel Step 15
Add in Excel Step 15

Step 2. Enter a number in a cell

Add in Excel Step 16
Add in Excel Step 16

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

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

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

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".

Recommended: