# How to add columns in Excel (with images)

Perhaps one day you will need, in Excel, to sum the values ​​of one or more columns. With SUM, it's a snap, whether you have a Windows PC or a Mac.

## Steps

### Method 1 of 2: Add the values ​​of multiple columns in Excel #### Step 1. Open your Excel document

Double-click the icon of your Excel document to open and edit it. The opening is done in Excel. #### Step 2. Locate the column that has the most data

Since you are going to sum all the cells in a number of columns, you must be careful not to miss any. This is why we must locate the lowest line.

### Suppose you have three columns of data and the longest goes from row 1 to row 20, the last argument of the function should make a letter appear, that of the column (containing at least one value) furthest to the right, followed by the number 20 #### Step 3. Locate the start column and the end column

If you add the values ​​of the column TO and those of the column B, the starting column will be the column TO and the one at the end, the column B. #### Step 4. Choose an empty cell

Click on the cell in which you want to see the sum of your columns displayed. #### Step 5. Enter the SUM command

Type = SUM () in the cell. #### Step 6. Enter the range of cells

Type in parentheses the cell reference of the first row of the first column, type a colon (:) and finally the cell reference of the last row of the longest column.

• Suppose you want to sum columns A, B and C, and the longest column has 20 rows, you type the following formula:

= SUM (A1: C20) #### Step 7. Press Enter

The formula in the summation cell is then replaced by the value of the sum of all data in all columns.

### Method 2 of 2: Sum remote cells in Excel #### Step 1. Open your Excel document

Double-click the icon for your Excel document to open and edit it. The opening is of course done in Excel. #### Step 2. Click a cell at the bottom of the column

If you are going to add up the whole column, this is the best location. Click once to activate the cell. #### Step 3. Enter the SUM command

In the cell, type = SUM (). #### Step 4. Enter the data range

In the parentheses, type the reference of the first line, type a colon (:), and then the reference of the last line.

• You have a column TO data from row A1 to A10 and you want the sum. In the bottom cell, type the formula: = SUM (A1: A10) #### Step 5. Press Enter

The formula is then replaced by the value of the sum of all the data in the column. #### Step 6. Do the same with all the other columns

If the columns are not all the same length, be sure to put the summation cells on the same row. #### Step 7. Choose an empty cell

Click on the cell in which you want to see the sum of your columns displayed. #### Step 8. Add the values ​​of the sums of the columns

In the parentheses of = SUM (), enter the summation cell references one after the other, separated by a comma.

• Suppose you have three columns whose sum of values ​​appear in cells A11, B23 and C15, you should get the following formula: = SUM (A11, B23, C15). #### Step 9. Press Enter

The formula is then replaced by the value of the sum of all the data in the sparse cells.