You're fighting the way Excel adjusts formulas

Change the array formula so there are no dependences on the shifted cells

Capture.JPG