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)
Bookmarks