Another sumif question

  • Thread starter Thread starter triniqueen
  • Start date Start date
T

triniqueen

Thanks to those who answered my previous question.
I have another dilema.... I'm summing up some rows to get cummulative
amounts, now I want to only add if the amount is >0, so if I paid off a loan
and the amount goes down to 0 then it shouldn't at the amounts from the
previous cells.

ex.
cell A1 has the 1000, B1 2000 In cell A2 the total is 1000 in B2 the total
is 1200 but I paid off the 1200 so in C1 there will be 0. How do I still do
cummulative totals in C2 without getting 1200 instead of 0.
 
See your other thread where I posted this:
You'd have to tell Excel somehow how much you paid. In C1, why don't you put
your payment as -3000...then C2 can still be a cumulative addition =B2+C1 and
the answer will be 0.
 
Back
Top