software

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
CoopAs 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
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
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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

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