EXCELL FORMULA NEEDED

[Belly]

Hi, can any one help me?

I need the formula for a simple spreadsheet. I've created a 3 column savings spreadsheet. Column A shows the name of my Banks, Column C shows the current balance of each account. I've managed to enter the formula in the cell at the bottom of Column C to show the total of all bank balances.

I would like to be able to enter a figure (the amount of money I've sent by post, interest received etc) in the cell in Column B so that it automatically adds itself to Column C and then clears Column B for re-use. Is this possible?

Thanx

 

[Belly]

I'm pretty sure you are wasting your time trying to make a formula to do that. It just can't do that kind of thing.

Personally I would rethink what you are wanting to achieve as this is not how spreadsheets are designed to work.

Ric.

Thanx for your advice. I will rethink and probably just use a calculator and enter the figure in column C as I have been doing.

It was worth a try and there are some Verrrrrrrry clever people on these forums.

Thanx Again

 

[Belly]

Ric

It works a treat, thanx very much.

you're a (gang)STAR !!!

I didn't know such things existed within Excell.