So A9 contains "=4" as shown. When I manually type "=A9+1" in the cell below, the formula works properly.
Also works correctly when I manually type "=A10+1" in cell A11.
But when I hover my mouse over the lower right corner of cell A11 to drag the formula down to cell A12, I get "6" as shown... If I click on cell A12 after I've dragged the formula down, it correctly displays "=A11+1" as the contents, but clearly, the result is wrong.
What's going on?
Thanks in advance.