cell calculation

[red]

how do i use one cell as a calculator, or to keep a running total within one
cell?

 

[Pete_UK]

Put this formula in B1:

=SUM(A1:A10)

Then, as you enter values into the range A1 to A10 the running total
will be shown in B1.

Is this what you meant?

Hope this helps.

Pete

 

[red]

Thanks, Pete, but what I need is to enter # into A1, then enter another #
into A1, & the result to be the sum of the 2 entered #'s, like a calculator,
but within the same cell. any hints?