EX:
1200
1205
1210
1215
Cell with total should contain 15
These are mileage numbers. At the end I need to know the total miles driven as miles are added. I need to be able to see the total miles driven as mileage is added. At the end of the week, I need to see total miles driven.
I'd probably find the max then subtract the min in your data range to get the mileage.
Use the MAX and MIN formulas
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
May be this.......
Assuming you have mileages in col. A starting from A2
So as per the formula A2 will always the minimum mileage and as per your example you have only 4 mileages listed in the column in the range A2:A5. The formula will auto calculate the total distance traveled once you add another mileage down the rows.
Please Login or Register to view this content.
You can adjust the range within the Max function as per your need.
Last edited by sktneer; 05-31-2014 at 12:28 AM.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
One way...
Data Range
This formula entered in C2:
=LOOKUP(1E100,A:A)-A2
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Formulas don't calculate as shown that they should.
I am using excel 2010
column A column L
Friday 1,500
Saturday 1,520
Sunday 1,525
Monday 1,530
Tuesday 1,535
Wednesday 1,540
Thursday 1,545
total: 45 (this #represents total miles driven)
Each day that you add mileage, the number at the bottom should continuous track total miles driven
Works OK for me.
Data Range
This formula entered in E2:
=LOOKUP(1E100,B:B)-B2
What result do you get?
It calculates a zero. Mine looks like
=LOOKUP(1E100,L:L)-L7
The problem is that you have a circular reference.
Try this one...
=MAX(L7:L13)-L7
Then you can copy that formula and paste it into L22, L30, L38. L46 and L54.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks