Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. -- Ksy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMIF Question | Excel Worksheet Functions | |||
SUMIF Question | Excel Discussion (Misc queries) | |||
SUMIF? Question | Excel Worksheet Functions | |||
SUMIF question | Excel Discussion (Misc queries) | |||
Sumif question | Excel Worksheet Functions |