how do i use one cell as a calculator, or to keep a running total within one cell?
R red Nov 25, 2008 #1 how do i use one cell as a calculator, or to keep a running total within one cell?
P Pete_UK Nov 25, 2008 #2 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
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
R red Nov 25, 2008 #3 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?
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?
