Title basically says it all
lets 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 -->
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. I hope my question is clear! Thanks in advance!