Jacob,
Almost what I need. The balance column now reflects the new payment, however
this is what I need

Invoice Name Amt Pmt/Dep Bal
100 Mike 500 300 200

- --------------------------------------------------
500 (300 + 200) = 500

After I enter the new 200 payment from Mike I would like to see this:


Invoice Name Amt Pmt/Dep Bal
100 Mike 500 300 0
100 Mike 200 0
----------------------------------------
500 500




"Bernard Liengme" wrote:

We might play with some SUMIF formula but in the long run you will be better
off learning to use Pivot tables. These sites will help
Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistan...lconPT101.aspx


I am a little concerned that Mike's 9/1 payment is in the SALES column but
this could be the result of the terrible problem we all have displaying data
in emails
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Maurice" wrote in message
...
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