using excel how would I create sheet for adding mileage?

C

Coop

trying to create a spreadsheet to keep track of mileage, all I know is
+k2+k3+k4 Etc.
but this adds all the totals, wich is incorrect..
any help?
TIA
Coop
 
D

David McRitchie

As far as what you show K5: =SUM(K2:K4)
but if you want to insert rows it would be better to use
in K5: =SUM(K2:OFFSET(K5,-1,0))
you can read about OFFSET in
http://www.mvps.org/dmcritchie/excel/offset.htm

If you really only know as little as you say you know, then
I would suggest you start reading/viewing some free online tutorials
http://www.mvps.org/dmcritchie/excel/excel.htm#tutorials

But the real problem I have with your question is that you do not
say what you want to do, what you have as input. presumably
having something to do with highway travel.
1. Trip distances with readings taken from odometer want to show
distances between turning points or other points of interest..
2. Miles per Gallon (MPG or KPG) with odometer readings, and
amount of gas (petro) purchased showing price/unit, cost.
3. Maintenance schedule based on mileage and running time.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top