Encounter all How-To Articles

How to Add together Values to Cells / Columns in Excel & Google Sheets

This tutorial demonstrates how to add values to cells and columns in Excel and Google Sheets.

add a value to multiple cells

Add Values to Multiple Cells

  1. To add a value to a range of cells, click on the cell where you desire to display the result, and enter = (equal) and the prison cell reference of the outset number then + (plus) and the number y'all want to add together.

For this example, start with cell A2 (200). Jail cell B2 will show the Price in A2 increased past 10. Then, in cell B2, enter:

add a value to multiple cells

As a issue, the value in prison cell B2 is now 210 (value from A2 plus 10).

  1. Now re-create this formula down the column to the rows below. Click on the cell where you entered the formula (F2) and place your cursor on the bottom right corner of the cell.
  2. When it changes to a plus sign, drag it downwardly to the rest of the rows where y'all want to use the formula (hither, B2:B6).

add a value to multiple cells 2

As a result of relative cell referencing, the constant (here, 10) remains the same, but the cell address changes according to the row you lot are in (and so B3=A3+10, and then on).

add a value to multiple cells 3

Add Multiple Cells With Paste Special

Y'all tin as well add a number to multiple cells and return the upshot as a number in the same jail cell.

  1. Get-go, select the jail cell with the value yous want to add together (here, cell C2 ), right-click, and from the drop-down menu, choose Copy (or employ the shortcut CTRL + C).

add multiple cells with paste special

  1. Later on that, select the cells where you lot desire to subtract the value and right-click on the information range (hither, A2:A6). In the drop-downwardly menu, click on Paste Special.

add multiple cells with paste special 2

  1. The Paste Special window will appear. Under the Operation department choose Add, and so click OK.

add multiple cells with paste special 3

You'll see the issue as a number inside the same cells. (In this example, 10 was added to each value from the information range A2:A6.) This method is better if you don't want to display the results in a new column and don't need to retain a tape of the original values.

add multiple cells with paste special 4

Add Cavalcade With Prison cell References

To add an entire column to another using cell references, select the cell where you want to display the upshot, and enter = (equal) and the cell reference for the first number then + (plus) and the reference for the cell you desire to add together.

For this example, calculate the summary of Price 1 (A2) and Toll two (B2). So, in prison cell C2, enter:

add a column with cell reference

To utilise the formula to an entire cavalcade, simply copy the formula down to the residual of the rows in the table (hither, C2:C6).

add a column with cell reference 2

Now, you have a new column with the summary.

add a column with cell reference 3

Using the methods above, you lot can also subtract, multiply, or divide cells and columns in Excel.

Add Cells and Columns in Google Sheets

In Google Sheets, you can add multiple cells using formulas in exactly the same ways as in Excel; except, you tin can't employ Paste Special.