I am trying to pull information from a schedule and am running into a
problem. The person updating the schedule deletes the previous week and my
formula result changes to #REF!. Is there an easy way to fix this.

I had fixed this using a Macro but he added rows and my Macro got messed up.

The formula I am using is =SUM(MANPOWER!F49:I49).
Thank you,
Havenstar