View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
TR Young TR Young is offline
external usenet poster
 
Posts: 21
Default Excel Circular Reference SUM HELP!

I don't believe that is possible. What you could do is insert a column to
the right of the colum in which you are entering the random input number.
Then, starting in the first cell of the column you just added, use the
formula =SUM(I4+3500). Then, do a copy and past all the way down the new
column. that way, whenever you enter any numbers in the "I" column, the new
"J" column will do the sum for you.
You can't have a circular reference in a cell and have it work, though. not
possible.

"SpecOpBookie" wrote in message
...
Hi all, I'm fairly new with Excel so let's see if I can get a quick answer
for my question :).

I am trying to add a base number to whatever number i Input within the
same
cell. For example: The Cell I am working with is I4. The base number I
want
is 3500. I want that added to whatever I type in the cell and summed in
the
same cell. So if I type in 2200, the sum would be 5700. =SUM(3500,I4) does
not work. I get a 0 in the cell and if I try to input 2200, the formula
just
erases. I need this formula for alot of cells all with the base number of
3500 and random input numbers. This IS possible isn't it?