This is on an excel budget sheet I've been using.
Column B is for the price of the item (-45 for gas money, 1700 for paycheck, etc).
B1 is the current amount of money in my checking account.
Column E has the following formula:
auto-filled down from E1 to the last item I have currently planned ahead for (currently down 115 rows).
As the formula moves down, it does a sum operation from B1 to the current row, effectively taking my current account balance against all planned changes in money.
|8/23/14||Current Cash in Checking||=SUM($B$1:$B1) is 150.00|
|Recurring||-15.00||8/24/14||Haircut||=SUM($B$1:$B2) is 135.00|
|Recurring||-17.72||8/27/14||Dental Insurance||=SUM($B$1:$B3) is 117.28|
|Recurring||52.30||8/30/14||Check for Miles Driven||=SUM($B$1:$B4) is 169.58|
The odd thing is this: on cells E2 to E14 I get a "Formula Omits adjacent Cells" error. Why it stops at E14 I don't know, and that's what makes me think it's a bug.
If I correct the formula, it just changes it from =SUM($B$1:$B14) to =SUM($B$1:$B15) (which isn't what I need at all), but then tells me that the formula doesn't match the pattern of the others around it.