Monthly Accounts spreadsheet help

[Trident229]

I am trying setup a spreadsheet to calculate my monthly accounts, so in B3 to B50 named items of income, in C3 to C50 amount’s of income.
In D3 to D50 amount of spending
The in E3 to E50 balance left in account, so I want to show balance in account only where I have entered the details the rest of the columns E4 to E50 shows up as Zero’s until I enter the next entry

[zbor]

Can you upload example workbook with your inputs and desire output? Make sure to hide private data.

[Trident229]

How do I upload

[zbor]

Click Edit -> Go Advanced and click Paperclip icon to upload excel workbook.

Check attachment

[Trident229]

sorry cant find click edit when I open go advanced I cant find paparclip

[oeldere]

go advanced => manage attachments

[zbor]

See above post, I've uploaded picture.

[Trident229]

Do it I think

[royUK]

You are using Excel 2007 so use the Table feature. This allows formulas to expand as data is added. Also, don't use mergedcells, use Centre across selection instead

[Trident229]

Not correct
in the In column is the amount coming into the account which would be 2200 has shown.
in the out column is the amount going out of the account which would be 200
And in the balance column is the amount which is left in the account, so when I enter another amount into the IN or OUT column it calculate automatic down the spreadsheet
So at the moment it should say I have 2000 in the account at the moment

[oeldere]

In the shown sheet you get your (up to data) account.

You can drag down the given formula.

you say: not correct.

It helps if you explains what is not correct.

[Trident229]

Sorry I am trying to explain as must as I can, just one other thing I have dragged down the balance column and there is figures of the balance all the way down the spreadsheet so where enteries havent been added yet could I just have it showing 0.00 in
Hope you understand

[oeldere]

this can be solved with

If(And(C9=0;D9=0) etc.

But why would you do it that way.

Maybe conditional format will help you better.

[royUK]

Not correct
in the In column is the amount coming into the account which would be 2200 has shown.
in the out column is the amount going out of the account which would be 200
And in the balance column is the amount which is left in the account, so when I enter another amount into the IN or OUT column it calculate automatic down the spreadsheet
So at the moment it should say I have 2000 in the account at the moment

That's what my example shows!!!

[Trident229]

Thanks for your help, I have some sort of a idea what to do, but its my wife that will be filling in the spreadsheet but asker her to drag down to the next cell is to much infor for her, the format you suggested If(And(C9=0;D9=0) etc I wouldn't have any idea myself how to enter it in to the balance column, could someone put it on the attachment file account;s xlsx

[royUK]

The example that I posted uses the Table feature. As data is added the formula copies down, No need for dragging or copying.