Try

=SUM(INDEX(A2:A4,0):INDEX(B2:C4,0,1))

gives 6 initially - gives 9 when B:B deleted