I want the column SALARY + DEBT to add the remaining 731$ to the next months calculation. And the month after it to add the last two months debt and so on.
I want the column SALARY + DEBT to add the remaining 731$ to the next months calculation. And the month after it to add the last two months debt and so on.
In D2
In F2Please Login or Register to view this content.
Drag both downPlease Login or Register to view this content.
If someone has helped you then please add to their Reputation
Not working :/
Can you upload your latest sheet with the calcs in?
heres my working one
You had made one mistake in your first formula. Thanks
@JohnTopley I've marked with 3 comments what I want.
in F2
=IF(D2<>"",SUM($D$2:D2)-SUM($E$2:E2),"")
You can also remove column B
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks