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