Referenced cells data changes constantly

[errtu]

So I have a sheet that contains the following formula:

=SumCellContents(F2)

But the data in that cell changes constantly as I need to move the data. However, if I use "Cut and Paste" to move the cell data it changes the formula, which I don't want it to do. It gives me back a #ref error.

How can I make it so the formula stays "locked" when I Cut and Paste data that the formula references?

Also have that problem with this other formula:

=TEXT($B$2,"")&" "&TEXT($A$13,"d-mmm-yy")

How can I make changes to the data in the referenced cells without them "moving" I tried $ sign but no luck.

 

[Andrew Poulsom]

A couple of ways:

=SumCellContents(INDEX(F:F,2))

=SumCellContents(INDIRECT("F2"))