I have several columns of data and a separate cell that contains a formula
referring to a range within one of the columns, for example
AVERAGE(A10:A100). Now I subject my data, including column A, to sorting, and
the annoying result is that AVERAGE now refers to different data. Is there a
way to avoid that?