My spreadsheet has a “header” area which contains multiple (absolute) references to cells in a “body” area. The “body” area is updated by the addition of new rows (in my case) on a daily basis. If I insert new rows at the top of the “body” area, the absolute references are modified to point to the same (old) cells instead of the cells in the new row; (if I add new “update/history” rows to the bottom of the “body” the references do not change and thus do not point to the most recent cells).
Here is a typical “header” cell content as I currently have it:
=(5MEDIAN(F$10:H$10)+4MEDIAN(F$11:H$11)+3MEDIAN(F$12:H$12)+2MEDIAN(F$13:H$13)+MEDIAN(F$14:H$14)/15
Any suggestions as to how to handle this (and avoid having to edit my formulae every time I insert a new body/data row)?