Menu

Using Average

Search this Thread

Prev

Previous Post

Next Post

Next

#3

Report Post

Posted to microsoft.public.excel.misc

James Silverton James Silverton is offline

James Silverton is offline

external usenet poster

Posts: 182

Default

Using Average

on Sun, 15 Oct 2006 16:21:18 -0400:

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
g there way to do this so I don't have to manually change the
g number each time?

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

Sorry, wrong way round (too much lunch :-), that would be
gallons per mile!

James Silverton
Potomac, Maryland

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

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
rolling average	William Okumu	Excel Worksheet Functions	5	May 25th 06 03:49 PM
Modified Average Function	PA	Excel Worksheet Functions	3	May 15th 06 12:20 PM
average 4 data from different sheets	[email protected]	Excel Discussion (Misc queries)	1	March 30th 06 12:23 AM
plotted Average	Micayla Bergen	Charts and Charting in Excel	4	July 15th 05 12:13 PM
What is this kind of average called?	havocdragon	Excel Worksheet Functions	3	June 24th 05 05:10 PM

All times are GMT +1. The time now is 03:06 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement