Issue with copying a formula

Hello,

I have a spreadsheet which contains four columns and about a thousand rows, in the fifth column i have a formula that adds up the four cells. When i drag this forluma down, the result doesnt change, the only way it changes is by clicking into the cell and pressing enter.

Why does this happen and is there another way to correct it?

Many Thanks