” “Thinking” that I must have “forgotten” to include columns G to I, Excel auto-adjusts the formula to include those columns. It matters not that the formatting in H and J mark them out as “something different to B to F”. It matters not that it makes the formula in J17 inconsistent with the formulas above. Oh no. It auto-adjusts the formula anyway…”