Identifying the first number in a row

[bowecas2]

I am working to create a fuel log for my company that shows when each of our vehicles purchased fuel, how much fuel was purchased, and what the odometer read at the time of fueling. Using this information, I am trying to show the MPG for each vehicle. FOr the miles, I am using a combination of Min and Max to calculate how many miles each vehicle went. To calculate the toatl amount of fuel used, I need to disregard the fuel that was put into the vehicle on the first fueling, but depending on the vehicle it varies as to what day it fueled. Below is an exemple of how the table is set up. I know I could use an if function to find the first instnace where the number is great than 0 and then summing the rest of the row, but I wanted to see if there was any simpler method for removing the first number from the sum of the row.


________________Jan 1___Jan 2____Jan3____Jan 4____Jan 5____Jan 6___Jan 7
65______Type____________________________________Gas_____________Gas
________Gallons__________________________________18______________22
________Miles____________________________________30172___________30553
74______Type____________Gas_____Gas_____Gas_____________Gas
________Gallons__________16______16______9_______________18
________Miles____________300479__300700__300781__________301030

[oeldere]

To my opinion it's easier if you rearange your data.

Put the data in the rows (e.g. column A)

Use one column for the car (65 or 74) (e.g. column B)

Use one column for Type / Gallons / Miles (e.g. C / D / E)

Then you be able to use pivot table to (e.g.) count your data.