I want to sum a column of numbers ONLY down to the current (not the last) row.
something like
B{THISROW} = SUM(A1:A{THISROW}).
THUS, IF COLUMN A HAS {10,3,2,5,8,12), THE CONDITIONAL SUM (IN COLUMN B) WOULD BE(10,13,15,20,28,40)
If data are in cells A1:A9, write in cell B1 the formula =sum($A$1:A1) and copy fill it down. The $ sign prevents, that the start cell of the range is adapted. Look for “absolute” and “relative” address in the Calc guides.
1 Like