Hi all

lets say I have a formula in cell A10 and the formula is

X=SUM(B1:B10)

if I cut and paste that formula to cell A12 the formula will then read

X=SUM(B3:B12)

is there any funtion i can add to this formula that will keep the cell values at SUM(B1:B10)