Novice needs: Complicated running totals adding substracting non contiguous cells contiguous columns
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
Last edited by innkeeper9; 08-19-2016 at 01:39 PM.
Reason: Forgot to include one caveat
|