I have a table with a basic formula:
The 7th column (
1038€94) is calculated with the formula
1133€34 - 94€40 + (empty cell). In others words, the 7th column is calulated by
(value in the row above) - (value of the 4th cell of the row) + (value of the 5th cell of the row).
All the rows have the same formula in the 7th column.
The first column is a date. If I choose to sort the rows depending on this date, the formula breaks because Numbers keeps 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 uses the cell above without specifying the line in the formula?