Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
rolling average | Excel Worksheet Functions | |||
Modified Average Function | Excel Worksheet Functions | |||
average 4 data from different sheets | Excel Discussion (Misc queries) | |||
plotted Average | Charts and Charting in Excel | |||
What is this kind of average called? | Excel Worksheet Functions |