As I read your question you want the total to be the LAST entry in the
column. If so, just put in your cell a21 =sum(a2:a20) if row 20 is your last
row. Then insert new rows before the sum formula and Excel will adjust or
put your total at the TOP and use =sum(a2:a2000). Or, you can use a
worksheet change macro to automate replacing the last cell with the total
regardless of what you do or where you put the new figure.

--
Don Guillett
SalesAid Software

"PFHMoney" wrote in message
...
I am attempting to track mileage within an excel spreadsheet... with each
entry being enter into the spreadsheet similar to that of a checkbook
register...

I have no idea how many entries there will be for the year, so my question
is how to have a running total of sorts whereby the last entry (be it 2 or
200 cells later) will have a total?