I have made an simple app, where i input the Kilometers of my car, when i put fuel on the tank.
I have made a simple Google Sheet and it works fine.
Titles on row 1, and data entered starts from row 2
I want to calculate the trip (Distance) just by Substracting the previous Kilometers with the newly entered.
If i enter Kilometers in the A column - i just want it to automatically substract A3 - A2
And the next time i enter the kilometers, it should substract A4 - A3 and so on.
I have tried to make an arrayformula in column E2 direct in Google Sheets:
But it keeps failing with #REFERENCE
Thanks in advance.