Excel Banking Summary Sheet

[kyle_engineer]

Here is what I did to emulate what you said you would want...



Column A Has the current total - the code for that cell is just

Code: [Select]

=G65536
Cell G3 (being the first sum cell) is

Code: [Select]

=SUM(E3,-F3)
All of the following G cells are the G4 pasted all the way down, but it's

Code: [Select]

=SUM(g3,(SUM(E4,-F4)))
That's all I did to get the above. It's very simple, and crude, but I think it achieves what you want. Usually you don't need to tell it so skip a blank cell (at least for math), because it counts it as a "0" and doesn't do anything to the equation.

If this works, you're totally welcome, if not, I'm frequently in the chat and you can always post here.

Also, anyone feel free to correct me if this isn't optimal.

Sincerely,
kyle_engineer

[patio]

Who is this for ? ?

[cstaniszewski]

It's for me. I am trying to get the "balance" cell to automatically update from the "balance" column. The code I currently have in it is =IF(AND(ISBLANK(E3),ISBLANK(D3)),"",E3+D3). The function is dragged down to a certain point, and I want the balance cell to show the balance at the top of the page also. So if I withdrawal a certain amount from say C11, the cell next to it will display what the remaining balance is. The "balance" column will only display a number if there is a deposit or withdrawal made. And I need that same thing shown at the top of the page. I hope that makes sense.

[kyle_engineer]

patio: Yeah it's for cstaniszewski.

khulekani: Totally the wrong thread for that. Please read this http://www.computerhope.com/forum/index.php/topic,33330.0.html as requested by the admin.

cstanszewski: Does this help at all? Do you not want the balance to continue down like that? You can also take a screen shot (ctrl+Print Screen [upper-right on keyboard]) to show us what you've got and better explain what you're going for.

[Salmon Trout]

patio: Yeah it's for cstaniszewski.

Where did you get the original question from? He has only made one post, which was after you started this thread.

[cstaniszewski]

It works, but I don't like the numbers going all the way down. It'll confuse me every once and a while.

[regaining space - attachment deleted by admin]

[Salmon Trout]

Where did you get the original question from? He has only made one post, which was after you started this thread.

What is the answer to this?

[cstaniszewski]

He used a different formula than what I had. Though, I don't want the balance to show in all the cells in beyond what has been utilized. And, I also want the cell labeled "balance" at the top (cell that is highlighted in red) to show the final balance in the "balance" column.

[Salmon Trout]

He used a different formula than what I had. Though, I don't want the balance to show in all the cells in beyond what has been utilized. And, I also want the cell labeled "balance" at the top (cell that is highlighted in red) to show the final balance in the "balance" column.

How did he know your question before you posted it? What's going on here?

[cstaniszewski]

Lol, we chatted before the forum was created. And he wanted to show me one of the solutions he came up with.

[Salmon Trout]

Personally I don't really think that threads should be done like that. It dilutes the value of CH as a resource for others. It's not just a chatroom for you and the other guy.

[cstaniszewski]

What?!

[truenorth]

I am absolutely positive that Salmon Trout can fully explain the observation he has made. However to give him a rest i'll venture an explanation of what he is trying to advise you and hopefully it shall be close to the mark.
A primary goal of the CH forums (second only to trying to assist a presenter of an issue) is to add to the knowledge enhancement of as many CH members (and indeed guests) on topics discussed. In this case you answered  (except to your chat partner) an unknown question or request for help. Therefore as Patio wondered where did this obviously an answer come from (as it certainly was NOT a request for assistance). Normally answers are only given in the forum to questions. You were depriving all but the chat participant the benefit of what the question was. An alternative if you wanted to keep your exchange private between just the 2 of you you could have used the PM route. However let me be quick to say we don't encourage that either for essentially the same reason. Hope this answers your "what". truenorth

[cstaniszewski]

I can somewhat understand that. But, that was not entirely true. He posted this so I can get more input. I also restated the question, though it was tough to explain, so that anyone else could help. I am looking for a solution to a problem, not a problem to a solution. So I will re-ask the question again. I am trying to get the cell B1 to display my current balance from the "balance" column. The formula that I am using in the "balance" column is as follows... =IF(AND(ISBLANK(E4),ISBLANK(D4)),"",F3-E4+D4). So, as an example from my post with my picture attached, I would want cell B1 to display what is being shown in cell F5. But, if I make a deposit or withdrawal in either cell D6 or E6, which would cause the cell F6 to show the new balance, I want the cell B1 to automatically update to the new balance (or automatically go from F5 to F6). I see What kyle_engineer did. But I don't want the numbers to show unless there is a deposit or withdrawal.

[kyle_engineer]

Salmon Trout: I understand where you're coming from. As I'm sure you noticed, I'm a bit new to this, but it makes total sense now with truenorth's clarification. In the future I will not post things in this way, as I can see that it would create a bit of confusion on the forums (especially if many people were to post like that).

truenorth: That makes total sense, and as said above, my apologies.

cstaniszewski: All he's saying is that to any random person who decided to check the thread before it was explained in these recent posts would have been confused as to the origin of the whole thing (as I imagine both Salmon Trout and patio were. Anyway, no harm, no foul. I'll see what I can come up with and let you know.

Of course, if anyone else reading this post has the solution, please don't hesitate to post it.

Sincerely,
kyle_engineer