I have a table with a basic formula:
The seventh column (
1038€94) is calculated with the formula
1133€34 - 94€40 + (empty cell). In other words, the seventh column is calculated by
(value in the row above) - (value of the 4th cell of the row) + (value of the 5th cell of the row).
All rows have the same formula in the seventh column.
The first column is a date. If I choose to sort the rows by this date, the formula breaks because Numbers maintains a pointer to the cells before sorting the data:
Is there a way to sort the rows without breaking the formula? Or make the formula use the cell above without specifying the line in the formula?