Yes, as I pay each bill in the range (C182 through C186), In the next
columns, E & F, I enter the date paid and the amount paid. As I enter the
amount paid in column E, I want it to decrease the "weekly total due" in cell
J. Make sense?

Thanks,
Roger




"T. Valko" wrote:

Do you use a cell to mark each amount as paid?


--
Biff
Microsoft Excel MVP


"Roger" wrote in message
...
How do I substract a range of cells, one at a time, from a cell that has a
sum?
For example, cell J187 is the sum of cells C182:C186, ( which is the sum
of
a weeks worth of due bills). What I want to do is, in cell K187, have a
formula that substracts each amount from C182:186, one at a time as they
are
paid, allowing me to see how much is stilled owed for that week. Is this
possible?

Thanks,
Roger