When deleting rows above my reference line, I get #Ref! in my referenceline.
How can I keep the proper reference in the reference line? Example:

Col A is a date field
Col B row 1 contains a Text "This is it." ,
row 2 contains =if(A2="",B1,"Why?"
row 3 contains =if(A3="",B2,"Because",,, and so on until you get to
the reference line which contains =(B10)... after I delete rows( 7,8,9 ) I
get #Ref! in row 10.