Hi
Say your data is in columns A to D, and your mileages are in D, In cell E1,
put
=SUM(D:D)
This will sum everythin in column D, and your total will always be in the
same location regardless of column length
HTH
Michael
--
Michael Mitchelson
"PFHMoney" wrote:
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?
|