Hey try this ...

Type =B3+C3 in cell C3.
Then go to Tools Options Calculation and select automatic or manual
calculation as you want. Then select *Iteration* and for Maximum
Iterations, type in 1.

This should solve your problem.



bouncer8 Wrote:
I want cell C3 to keep the total even when i change cell B3, for example
say
the total in C3 is 10 then i want to keep changing B3 but to keep
adding onto
C3. So C3 is 10 then i change B3 to 6 so C3 should read 16 then i want
to
change B3 again to 3 so the total in C3 should go to 19.
Anybody any ideas?


--
workerboy
------------------------------------------------------------------------
workerboy's Profile: http://www.excelforum.com/member.php...o&userid=34121
View this thread: http://www.excelforum.com/showthread...hreadid=573051