Assuming $2180.00 is in cell A1

to calculate the total of account #94411 use:
=SUMIF(C1:C9,94411,B1:B9)

You can automate the formula for every account by replacing the text
94411 with the cell that contains that account number.


--
carstowal
------------------------------------------------------------------------
carstowal's Profile: http://www.excelforum.com/member.php...o&userid=37476
View this thread: http://www.excelforum.com/showthread...hreadid=571413