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?
How to create sum in Numbers up to a specific row
numbers
Related Solutions
This functionality is embedded and its default behaviour. Of course if adding a row will be done using this option:
If I'm not mistaken, tables have a small yellow dot on the highlight box at the bottom once selected.
Clicking and dragging this dot downwards will duplicate the rows (and hence their enclosed formulae).
Related Question
- Formula required to add time at rest
- How to create a running total in Apple Numbers (4.0ff)
- (Numbers) COUNTIF values from one column match another column
- Numbers Sum of all values in a column where another cell within the row matches text
- Equivalent of =SUM(ABOVE) in numbers
- How to prevent displaying the total sum of A + B if columns A + B are empty
- How to add all of the text strings in all of the cells in a row together
Best Answer
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: