analyst storm wrote:
I want to fill a column of cells with the same fomula in each cell but when a
drag the cells the formula keeps changing by adding 1 to each cell reference.
I want the same formula in each cell over namy rolls in a column.

Look up 'cell and range references' in the help
It's called absolute addressing
Basically, put a $ sign in front of the reference you dont want to change

Eg.
$B1 The B won't change
B$1 The 1 won't change
$B$1 Both the B and the 1 won't change

George