Excel Help please!!???

Jameshill675 · 21 May 2007 at 16:35

Can someone please Help?

I have a cell with a value in e.g.(200,000)

I want to be able to input another figure and the cell adds up to a total.

So If I input 200,000 again the cell would show 400,000.

Does anybody know how I could do this?

[TW]Fox · 21 May 2007 at 16:37

Put 200,000 in the cell, we'll say its Cell A1. Then in Cell C1 type:

=A1+B1

Then just type whatever number you want in B1 and bingo.

Jameshill675 · 21 May 2007 at 16:40

I can't do that mate.

I am workign ona workbook and I have a hell of a lot of figure to be adding up.

This will really help save me time.

platypus · 21 May 2007 at 16:46

Reminds me of that Oracle thread.

Post your email address and I'm sure someone will email you the solution.

Majago · 21 May 2007 at 16:46

Put your figures in say a1 and in b1 type =sum(a1:a1000)

Then input your figures all down column a.

total will update in cell b1.

Job done.

Jameshill675 · 21 May 2007 at 16:50

Email address is [email protected]

What I am saying is mate I don't have any cells available in the workbook(everything is taken).

I need to be able to input 2105 then input 2405 and it calculates it to 4510 automatically.

[ASSE]Hinchy · 21 May 2007 at 16:50

Jameshill675 said:
I can't do that mate.

I am workign ona workbook and I have a hell of a lot of figure to be adding up.

This will really help save me time.

Put the 200,000 figure in cell IF231, that should be far away enough from all of your figures. Or create a new sheet and calculate it all using that.

Majago · 21 May 2007 at 16:52

Right I see, could you not type your formula into a new sheet but get it to look at the first sheet as well?

Otherwise this website is pretty useful for excel queries.