I am new to Excel and have Excel 2007 if that makes any difference.

I am just trying to write my own vehicle logbook for my own vehicle which is
used personally and for work. To denote this I have done the following:

value 1  value2  Notation  work column Personal column

The above are different cells. Value 1 is the start mileage. Value2 is the
end mileage. Notation is either P or W. Work Column has the formula
=IF(Ex="P",Dx-Cx,) where the "x" equals the cell number (eg, E6 or whatever)
and of course it goes for rows from A downwards. The end result, so far, is
that if it was a personal use then the value appears in the Personal column
and if a work use then in the work column. The column that the value does
not go in shows a simple 0 which is fine by me. I would prefer it to be
blank but it is OK for now.

My problem is this. I would prefer to have, below the last entry, a 1 line
gap and then a total for each column which is easy enough to do but what I
would like is that when I want to enter a new entry, I can make the autosum
for each column automatically move down one line. As you may guess, the
logbook will last for a full financial year and then when the total year is
over, I just create a new workbook for the next year and of course keep each
excel file for my tax records, printing them out if necessary.

Is it possible to have those total columns move down auto when I enter a new
trip value? If so, how can I do that, please?

Apologies for my newbieness in advance. I never had a use for Excel
knowledge before but I bought Office 2007 and have bumbled and stumbled
around to the point that I have everything I need excepting the auto
advancing totals. It took a good 30 minutes to get this far to my
embarrassment!

Thanks in advance.