value inputs..another formual question

  • Thread starter Thread starter gabrielevery
  • Start date Start date
G

gabrielevery

Well I'm full of questions today...I'm really starting to understan
Excel and I'm enjoying working with it.

I'm making a sheet that will keep track of someone that is running
tab with us. I'm inputting how much is owed on each specfic day, an
the value's are added up and outputted in a "grand total" cell.....
Now what happens when this person pays on the account, is there any wa
I can input how much he pays which will be subtractred from the gran
total, without destroying any information of past money spend (i wan
to be able to keep a grand total, average visit total, an
yearly/monthly grand total
 
If you want the payment to be included in the same column as what is
owed, then you will have to enter it as a negative amount.
Alternatively, you could have one column for what is owed (as you have
now) and another column for payments, and each column could have its
own SUM( ) formula, the difference of which at any point in time is the
amount outstanding.

As your list of transactions will grow ever longer, I would suggest
that you put the SUM( ) formulae on the top row (maybe with a different
background colour to stand out) and to freeze the panes so that the row
is always visible even if you are entering data on row 200 (say). The
SUM formulae could have a very big range, eg C2:C65522, so you don't
have to worry about adjusting it as you add new transactions.

I would suggest that you have a date column in A and brief descriptions
in column B.

Hope this helps.

Pete
 
Back
Top