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?

Thank you