How to deduct from a cell until 0 then deduct from next cell?

[itzzjason]

Hi. I'm trying to create a spreadsheet to help keep track of bills.

I'd like the spreadsheet to calculate how much money I'll have left after paying bills per month.

Example:

	A	B	C	D	E
1	Checking account #1 balance	$10000.00		Water bill	$100.00
2	Minimum balance	$1500.00		Gas bill	$50.00
3	Usable Balance	$8500.00		Electric bill	$75.00
4	Remaining balance			Car payment	$300.00
5
6	Checking account #2 balance	$5000.00
7	Min. balance	$100.00
8	Usable balance	$4900.00
9	Remaining balance
10
11	Overall remaining balance

<tbody>
</tbody>

I want to deduct the bills' amount (column E) from the first bank account until it reaches $0.00 (cell B3) then deduct any remaining bills from the next bank account (cell B8).

What formulas can I input into cells B4 and B9?

 

[mikerickson]

If column C is the amounts of the various bills.
In B4, =MAX(0,B3-SUM(C:C))

In B9 =B8-(SUM(C:C)-(B3-B4))