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:

=SUM($B$1:$B1)

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.

Example values:

Current Balance	150.00	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.

Answer rating: 100% (QA)

Hi As a side note select the error box for one of your cells say E5 Look at the error box The second ... View the full answer