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