Google Sheets – How to Drag Down ‘A1:A2’, ‘A1:A3’, ‘A1:A4’

google sheets

Let's say every day (1 day = 1 row) a number is being added in column A
I want to have column B show the total of these numbers. However, if I drag it down, it keeps moving 'B1' too, while I only want the second one to move +1 –>. So:

Cell B1: '=A1' 
Cell B2: '=SUM(A1:A2)'
Cell B3: '=SUM(A1:A3)'
Cell B4: '=SUM(A1:A4)'

etcetera.
Dragging this down doesn't give the wanted result.

Best Answer

You don't do this by increasing the formula by a cell for each row. This is not possible.

Instead, you use as the formula 

cell B1 = A1
cell B2 = SUM(B1, A2)
cell B3 = SUM(B2, A3)

Now you can drag down the formula from B2 and B3 (don't include B1 in the selection!) for as many rows as you like.

Related Topic