I set up a simple function, e.g., =sum(B2,B5,B7,B9). If I delete rows 5, 6
and 7, the cell that used to give me the total now shows #REF! My question
is how can I delete the rows and still get the sum for adding B2 and
B9--without having to start over and select cells B2 and B9.