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

#### itzzjason

##### New Member
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?

Last edited:

### Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

#### mikerickson

##### MrExcel MVP
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))

Last edited:

Replies
2
Views
282
Replies
10
Views
539
Replies
10
Views
7K
Replies
0
Views
356
Replies
2
Views
414

1,136,847
Messages
5,678,109
Members
419,746
Latest member
tysonboy82

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back