Dec 06 2023 06:14 AM
Using an average formula =average (d4:h4)for 5 cells in a row then delete d4 shift cells left formula changes to = average(d4:g4) , how can I stop this changing?
Dec 06 2023 07:25 AM
Dec 06 2023 09:35 AM
Probably best to clear contents rather than delete but here's an option:
=AVERAGE(TAKE($D$4:$ZZ$4,,5))