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 `SUM(B10:D10)`

to `SUM(B10:M10)`

.

However, the formulas in `O10`

and `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.

isthe formula in`N2`

? – cybernetic.nomad Apr 10 '18 at 15:08