Hello Everybody,

I have a request that I hope will not be too difficult and is also possible.
The project I am performing is a personal one and is in relation to
automobile milage. In column "C" I have the speedometer reading at the end
of each week. What I want to do, and this is in one column, to subtract the
current speedometer reading from the previous reading and then each week
average the readings.

I want the column to have the average weekly distance in it each week for
the year to date. Say for week one the distance travelled is 400 the next
week is 450 so in the space next to the second week I would like the average
of 400 and 450 which is 425 then if week three is 300 the average of the
three numbers would be 383.3 and so on.

So in summary the formula must first work the difference between the two
distances and then find the average of all distances. In the cells where
there has been no calculation made it must remain blank until the time it is
used.
--
Steven.

In God we trust, all others we virus scan.