Changing cell refrence...help

[dhansen]

I am having a problem with the cell refrence changing in my formula when I click and drag information. example - formula is in cell H4, and refers to info in C4, D4, E4 & F4. When I highlight C4, D4, E4 & F4 and click and drag to a new row the formula changes and follows it to its new position. Example - if I move the info to row 6, the formula in cell H4 now refrences the info I moved to row 6...I am holding the column refrences constant.

Please help!

Thanks.

 

[just_jon]

Anchor the row numbr with a $, as in -- C$4 -- you can anchor the column in the same manner.

 

[dhansen]

Thanks for the reply. I did that and it did not work.

 

[just_jon]

use copy/paste.

 

[Juan Pablo González]

Why didn't it work ? how did you try it ? it should be what you want....

 

[dhansen]

did copy and paste...still same problem. I do not know why it didn't work.
I anchored the column and the row with $ then tried to click and drag and copy and paste. I am stumped!