cell calculation
 

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

cell calculation
 

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

On Nov 25, 2:19*pm, red wrote:
how do i use one cell as a calculator, or to keep a running total within one
cell?

cell calculation
 

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?

"Pete_UK" wrote:

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

On Nov 25, 2:19 pm, red wrote:
how do i use one cell as a calculator, or to keep a running total within one
cell?