Sorry posted this response was intended for another post

Enter "Paid" to the next cell for bills paid RANGE D182:186
then use this
=SUMPRODUCT(--(D182:D186<"Paid"),(C182:C186)) in any cell


"Sheeloo" wrote:

Add a $ before the column letters in your formulae before choosing PASTE
SPECIAL and click on Formula and Transpose both.

Relative references get updated while pasting formulae.

"Roger" wrote:

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