ExcelBanter - View Single Post

James Silverton

Hello, !
You wrote on 15 Oct 2006 12:50:56 -0700:

g I'm tracking my MPG's for my car. Column A has the odometer
g reading, B is Gallons, C is Miles Traveled, D is MPG, and E
g is Average. I just started doing this three-fillups ago, so
g my average right now consists of =AVERAGE(D3:D5). If I
g change the "D5" to something greather than 5, I get a
g #DIV/0! message. I'd rather not change that 5 to a 6 when I
g want my next calculation and then to a 7 and so on. Is there
g way to do this so I don't have to manually change the number
g each time?

I doubt if you really want to average individual mpgs. Why not
add the gallons used and divide it by the odometer reading (less
whatever was its starting value) to get the overall mpg?

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not