Identifying text in a column, reading a sum in the next column an
subtracting that number from a cell with the total.

For instance:
If one of the cells from A2:A10 = "Visa Payment" then subtract (an
here's where I get lost) the sum ($$ payment) from the correlating cel
in column B from a cell with the total.

I have the columns named: Date, Debtor, Payment and Total Due.

Any ideas? I think it's a simple IF, THEN, ELSE formula, but I can'
get my brain around it.

Thanks

--
Message posted from http://www.ExcelForum.com