Hi there,

The best I can suggest is that you add in a blank line above row 2 and below row 26 and then expand your formula to include these. i.e, now you have c2:c26. by adding the two lines, you will have c2:c28 with your first line of data being on row three. This way, you can move all lines up and down without affecting the formula as long as you don't go "outside" the new boundaries. You will be able to move c4 to c3 and the total will remain correct (as long as you place c3 where c4 was of course!). Otherwise, use the row insert function to insert new rows before moving items around.

Hope that helps.

MC