One solution would be to edit your MPG calculation to not render error
messages. Try something like this:

D3: =IF(ISERROR(C3/B3),"",C3/B3)

This formula says "If calculating mileage returns an error (as it will
if I haven't entered miles or gallons yet!), leave the cell blank.
Otherwise, do the math."

Then when AVERAGE steps in, it isn't thrown by these error messages.
Instead, it'll just ignore the blanks.


Jim

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

Thanks.