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

Attached Images

xl-worksheet.jpg (123.5 KB, 26 views)

In E33: =SUM(E16:E31)
In F18: =IF(E18,$F$16-SUM($E$18:E18),""). Copy down to F31.
In F34: =LOOKUP(2,1/($F$18:$F$31<>""),$F$18:$F$31)

It works perfectly. Thank you so much. I did 3 sheets and even found out how to get the ending balance of one to show up at the beginning balance of the next. However --- it worked so perfectly it made me realize that I made a mistake in my layout

I'm not very good at explaining, I get too long trying to make sure I cover everything, it's why I use images, but I will try. Row 22, Owner, can't be in that area, it is a debit but not an expense and when I got things working with your formulas I realized that. That row 22 needs to be between Row 33 Total Expenses and Row 34 Ending Balance. So, I cut row 22 which made Total expense row 32 and then I inserted the cut cells after it so that Owner became 33 and Ending Balance 34. The total expenses are correct now, but of course the ending balance is not. And, though I can get an idea of what the first two formulas you gave me are doing, I can't figure out anything on the last one. Can it be modified to subtract that Owner distribution before putting in the ending balance? Or is there a different function that would have to be used?

Thank you so very much for your help!

Ruth

The formula I said you should enter in F34 was unnecessarily complicated. I have made a simpler one in the attached.

Hope I have understood you correct.

Attached Files

RunningTotals.xlsx (9.5 KB, 10 views)

What about a little reply?

Hi,

I am so sorry. Everything works terrific, and that formula I understand I should have posted that day right after I tried it, but I put it off while I packed to go out of town and just plain forgot. I just got back yesterday, please accept my apology. I am usually not so flighty.

I thank you very much for all your time and your help. I hope that you will continue to help me when I post my next question, and there is another question, but on a different issue, so I think I should post it as another topic, once I figure out how to ask it I promise to post back immediately from now on.
and thank you again so very much.