Formula changing while adding column in excel?

Hello there,
Concerning a exceed sheet through which i own given any formula, as an example, =average(a1:f1), now i would like to add one more column involving then blueprint being wrong, when my organization is adding innovative column the typical is becoming to the 7 content, i merely want regular of first 6 tips.

Try this kind of formula:

=AVERAGE(INDIRECT(“A1:F1”)).