Simple calc query

  • Thread starter Thread starter Diamontina Cocktail
  • Start date Start date
D

Diamontina Cocktail

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.
 
To get a blank rather than a zero use =IF(Ex="P",Dx-Cx, "")

Can the Sum be at the top of the table? =SUM(A2:A2002)
I am assuming you will not have more than 2002 entries

OR in XL2007 make the table into a Table (an Excel table not just a block of
data)
Then you can have a totals row
But you will need to right click this row and use Inset every time you want
to add data
Or use CTRL+SHIFT+T with a Table cell selected to toggle the Total row
on/off; but I found I had to rest the total value from COUNT back to SUM
each time

best wishes
 
Back
Top