I have a weird error which caught me out recently. I want to understand if it is expected Excel behavior and if so, is there a way to prevent it or turn it off?
You can recreate the issue by creating a table like the image above. Depending on how I enter the data I get different results.
If I start in column B and go across, putting in 1 along the row then the formula for the total of Col 1-3 changes (in column N).
On Row 9 I went across putting in 1 in each cell and the formula in N10 changed from
However, the formulas in
P10 did not change. Why?
In Row 5 and Row 1 I put in the numbers in a random order and the total formulas stayed the same.