Help with cummulative totals

T

triniqueen

I'm summing up a row 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 add 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 3000 but I paid off the 3000 so in C1 there will be 0.
How do I still do cummulative totals in C2 without getting 3000 instead of
0?
I need to have cummulative totals throughout each cell that would to take
into consideration the amounts that were paid off.
 
K

KC Rippstein hotmail com>

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.
 
K

KC Rippstein hotmail com>

Yes, that's what you'll get using what I said. If in C1 you entered -2000,
then the formula in C2 (=B2+C1) would show your running balance as 1000. If
you entered -500, then C2 would show you still owe 2500. The point is you
cannot put 0 in C1 or anywhere in the first row, as you are tracking either a
debit or credit in the first row so zero makes no sense as an entry in any
cell in the first row.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top