Hi. I need help with keeping a value of a cell constant even after deletion of a row. For instance, in cell J1 I have the sum of B2..B13. I also have data after row 13. I want to be able to delete one of the rows (b2-b13) and not have the value of J1 change to =b2..b12. I want to keep it at b2..b13. Is this possilbe? Thank you in advance
Bookmarks