How to create sum in Numbers up to a specific row?
I have column which contains prices for my work. The last row of that column should contain the total. Currently I have to adjust the SUM() calculation every time I add or remove a row.
Can I somehow magically sum up to the row the SUM() formula is contained in?
Solution 1:
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:
