Add a Number to a Cell and place the number in the same cell
very easy
1. put the value in A2
2. copy A2
3. Select A1 and paste/special with the add checked
A1 will now have its old value plus the value you entered in A2
--
Gary's Student
"Rod" wrote:
If I have a Number in Cell A1 and then want to add say 10 to that number, I
then want to replace the Number in A1 with the new results.
If A1 has 10
Then A2 has 20
I want A1 to then say 30.
If I change A2 to then 10 again
Then A1 changes to 40.
I need like a running SUM in a Cell.
|