Sub test()
Range("A1").End(xlDown).Offset(1, 0).Select
ActiveCell.FormulaR1C1 = "=SUM(R[-7]C:R[-1]C)" <<See Note
End Sub

First please verbalize the "=SUM(R[-7]C:R[-1]C)" syntax, I can't get it..

<<Note : this line created separately using Macro recorder with Cell A8
active at the time. It appears to be an absolute address (with the 7 in
it).
How can I change the "=SUM(R[-7]C:R[-1]C)" portion
on code to always run from one cell up to the top row of my column?

Thanks in Advance,,