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.