If all you want is a total outstanding, and you have invoice amounts in one
column, say D, (as positive numbers) and payments in another column, say E,
(again as positive numbers), =SUM(D1:D500)-SUM(E1:E100) will give you the
outstanding balance.

On Sat, 19 Feb 2005 07:23:01 -0800, BradLewBooks
wrote:

i am trying to keep track of all the invoices i receive from my distributors,
i run a bookshop. I am trying to creat a column which gives me a total
amount outstanding, however some of the columns have invoices paid and unpaid
and i want to mark items paid so they won't show in the total outstanding.