Novice needs: Complicated running totals adding substracting non contiguous cells contiguous columns

[innkeeper9]

Hello,

I am a total novice with excel and have never used any kind of program that you use to make templates for anything, or any kind of a database program to do anything. So, I downloaded a free template that pretty much did what I needed, except for a couple of things which I did figure out how to put in and rearrange. I now need for three things to happen:

1. Each item in the debit column [E] must be subtracted from the beginning balance in the Balance column [F] showing a running total for each

2. The items in the debit column [E] also must add together and put the total debits in 2nd from the bottom cell of that column.

3. The Balance column [F] which has the running totals from subtracting the debits has to have a final ending balance at the bottom cell of that column.

[EDIT 1:36pm 8-19-16]

I forgot to say, the reason for the extra blank cells in the red box of Column E is that in other months there might be more expense items in that column so I figured there must be a way to make sure the formula used would be able to include those if they had items in them.

I have attached a screenshot with all the information. Thanks for any help.

Ruth