Hi
I have a spreadsheet that adds the numbers in a column on sheet 2 eg C3 to C43 and puts the result in a cell on sheet1
I now want to insert a new column in sheet 2 column C so that I can add more numbers and get a new result on sheet1
But the formula seems to stay with the original column so that the cell in sheet1 is now looking at D3 to D43
How can I lock the formula on column C
Many Thanks