How to create sum in Numbers up to a specific row?
You can do this using header and footer rows. These automatically adjust the formulas contained within them based on the number of rows above.


Make sure you have the footer row enabled:


In the footer cell, enter =SUM↩︎.
Select the column by clicking the relevant header cell or column reference.


The formula will automatically adjust from now on.



An animation for further explanation: