Forum Discussion

Cookbailey's avatar
Cookbailey
Copper Contributor
Dec 06, 2023

Formulas

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?

Resources