I am having trouble figuring out the formula for my budget.
Cells look like this
A B C D
DATE WEEKLY BILLS TOTAL
2015 $50 $1,956.73
Jan 16 $50 $70 $1,936.73
I want to formula cell D so that when I insert data every week into cells B & C it will add my Total in D carrying the balance from the previous balance in D. As this is a yearly budget I am finding that every formula I use, carry's the total in D all the way down the page. I want cell D to be blank down the page, until which time I enter data in B & C.
Can anybody help me?