How to add columns in Excel (with images)

How to add columns in Excel (with images)
How to add columns in Excel (with images)
Anonim

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

Add Up Columns in Excel Step 1

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.

Add Up Columns in Excel Step 2

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

Add Up Columns in Excel Step 3

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.

Add Up Columns in Excel Step 4

Step 4. Choose an empty cell

Click on the cell in which you want to see the sum of your columns displayed.

Add Up Columns in Excel Step 5

Step 5. Enter the SUM command

Type = SUM () in the cell.

Add Up Columns in Excel Step 6

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)

Add Up Columns in Excel Step 7

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

Add Up Columns in Excel Step 8

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.

Add Up Columns in Excel Step 9

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.

Add Up Columns in Excel Step 10

Step 3. Enter the SUM command

In the cell, type = SUM ().

Add Up Columns in Excel Step 11

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)
Add Up Columns in Excel Step 12

Step 5. Press Enter

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

Add Up Columns in Excel Step 13

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.

Add Up Columns in Excel Step 14

Step 7. Choose an empty cell

Click on the cell in which you want to see the sum of your columns displayed.

Add Up Columns in Excel Step 15

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).
Add Up Columns in Excel Step 16

Step 9. Press Enter

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

Advice

  • To sum the cells from A1 to A5, in the SUM () function, you can operate in two ways: either you put the detail

    (= SUM (A1, A2, A3, A4, A5)), or you take the shortened formula

    (= SUM (A1: A5)).

Popular by topic