View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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.