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

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....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.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Coop" wrote ...
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