Hello all,
I am tracking hours over the year with the weekly hours total placed in cell M3. In cell N3 I have this equation =AVERAGE('WEEK 1:MASTER'!M3) which is keeping a year to date average of hours. which is working great, except if I add a new person to the sheet to track the hours, the...