Col A Col B Col C Col D Col E Col F
INVOICE# DATE Name SAmount Deposit Balance
101 1-Aug Mike $500 $200 $300
102 2-Aug Mary $100 $100 0
103 3-Aug John $200 $100 $100
101 300

The below formula will return the balance (in Col F) as soon as you type the
invoice number. In the above table the formula to return the balance in cell
F5 (which returns 300)is

=IF(A5="","",IF(E5="",SUMIF($A$1:A4,A5,$D$1:D4)-SUMIF($A$1:A4,A5,$E$1:E4),SUMIF($A$1:A5,A5,$D$1:D5 )-SUMIF($A$1:A5,A5,$E$1:E5)))
(all in one line)

--If invoice number is blank..F5 will be blank
--If invoice number is keyed and deposit amount is keyed ;then the formula
recalculates the new balance
--If deposit amount is blank then the formula returns the existing balance

Try with the above table as a sample and then adjust to suit your
requirement. Try and feedback....

--
If this post helps click Yes
---------------
Jacob Skaria


"Maurice" wrote:

I have a table like this

A B C D E F
INVOICE# DATE NAME SALE Amount Rec/Deposit BALANCE
101 8/1 Mike $500 $200 $300
102 8/2 Mary $100 $100 0
103 8/3 John $200 $100 $100
.
.
9/1 Mike $300 0

When Mike comes in on 9/1 to pay off his $300 balance from invoice #101 on
8/1. I would like to record the payment and the fact the the balance for Mike
is now $0 on this spreadsheet.
How do I look up the balance for Mike? Either based on the invoice #, Name,
I don't care. Eventually the list will contain 100s of transactions so I
can't look it up manually


Please