Or if the OP never leaves any blanks in-between one can use a dynamic range
click insertnamedefine, give it a name like MyRange, in the Refers to box
put


=OFFSET(Sheet1!$D$1,,,COUNTA(Sheet1!$D:$D),)


click OK

then use

=SUM(MyRange)

which will adapt to any new entries in the D column


Regards,

Peo Sjoblom



"Michael" wrote:

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?