Hi I have a spreadsheet I update daily for my vehicles mileage. In the first column lets call it A I keep track of my daily end of day mileage. Is there a formula that will allow excel to automatically calculate the difference from the first mileage (A2) which will alway be a constant to the newest updated mileage that I input on a daily basis to find the difference of the total amount of mileage driven. I have been manually updating the formula and so far it seems a hassle it'd be awesome if excel could do this automatically whenever i inputed a new number in it would calculate difference the most current mileage to the constant first mileage.

Perhaps I'm oversimplifying this; or maybe I just don't understand the question. A1 - daily mileage

A2 - first mileage

A3 - enter the formula =A2-A1That will give you the difference.

No, everything is listed in one column in descending order of mileage.

Basically I want excel to automatically calculate the difference from the newest entry i input to the original mileage.The original mileage being the first mileage which is A2. Does that make sense? I did the way you mentioned for quite a while but I just want something automated, a formula that automatically update telling me total amount of miles driven.

maybe this will work:

a1 mileage this month =large(a3:a33,1)-a2

a2 mileage starting

a3 miles at end of day1

...

a33 miles at end of day 31

That worked flawlessly, Thanks!

Ask Your Question

Weekly Poll