Monthly milage calulation

**rlevesque** · 10-24-2012, 02:56 PM

I have been tasked with creating a form to track mileage on several vehicles in our fleet.

What they want to do is calculate the mileage difference every month for a total year, but only show the mileage difference in the total mileage column.

For example: row 1 list every month for the year starting with DEC of the previous year.
Capture.PNG

The final cell is for the total (P2). That cell needs to calculate the difference over every month and only show the subtracted total from each month. example: the difference between cell F2(23,605) - E2(22,000), answer 1,605. Then it needs to change the value in P2(1,605) to be the difference between G2(24,812) - E2(22,000), answer 2,605. the new answer of 2,605 now needs to replace the number P2.

**e.isayev** · 10-24-2012, 03:12 PM

=index(c2:l2,0,match(1,(c2:l2>0)*1,1))-index(c2:l2,0,match(1,(c2:l2>0)*1,0))

**rlevesque** · 10-31-2012, 08:23 AM

Thank you. I did try the calculate you posted but it does not work.

He is a jpeg of the sheet I am using. Please keep in mind that there will be nothing in the blank cells until that month is over.

Mileage report.JPG

Please help.

Originally Posted by eisayew

=index(c2:l2,0,match(1,(c2:l2>0)*1,1))-index(c2:l2,0,match(1,(c2:l2>0)*1,0))

**rlevesque** · 10-31-2012, 12:39 PM

Just tried the formula again; =index(c2:l2,0,match(1,(c2:l2>0)*1,1))-index(c2:l2,0,match(1,(c2:l2>0)*1,0)) and found that this step was missed:

Press CTRL+SHIFT+ENTER to enter the formula as an array formula.

**oeldere** · 10-24-2012, 03:14 PM

in F3

=f2-e2

and drag to the left and right.

**FDibbins** · 10-24-2012, 03:51 PM

not every1 can open .png files, myself included. It would be far better if you could upload a sample of your file, showing what you have, and an example of your expected outcome. Thanks