running total problem

[JRsoccer08]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I created a checking worksheet much the same as is given in excel as a ledger sheet. I did this because I want to create other worksheets to track the budget as well. But anyways, when I create a running total in the far right column by just copy and pasting it, the total created by the most current transaction entry, enters down the entire "total" column. Is there some way to have the cells in this column blank until a transaction is entered in their respective row? (the ledger template given in excel does this but idk how). Also, if you know of anyway to create a drop down menu to choose from (like the ledger template as well) for a column, like my category column, that would be greatly appreciated. Thank you.

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

I created a checking worksheet much the same as is given in excel as a ledger
sheet. I did this because I want to create other worksheets to track the
budget as well. But anyways, when I create a running total in the far right
column by just copy and pasting it, the total created by the most current
transaction entry, enters down the entire "total" column. Is there
some way to have the cells in this column blank until a transaction is
entered in their respective row? (the ledger template given in excel does
this but idk how). Also, if you know of anyway to create a drop down menu to
choose from (like the ledger template as well) for a column, like my category
column, that would be greatly appreciated. Thank you.

One way:

Assume the row entry is in column A, and you want to do a 10-row
running total:

B11: =IF(A11<>"",SUM(A2:A11),"")