3D equation

[JustOneQuestion]

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 equation is not averaging correctly.

For example: I have added a line and copied the equation into M10 & N10 following this I adjusted my 3D equation as such =AVERAGE('WEEK 11:MASTER'!M10) I changed the red text to only pull from week 11 to the master sheet, because there is no data before week 11. It seems to be averaging all the sheets, because my average that comes from this equation is much lower than the actual average. It is throwing out 38.7 as the YTD average, but I ran it manually (3 times to make sure I was correct) and the average should be 47.6.

Anyone have some thoughts?

Here is a link to my last post - which lead me to the 3D equation.

https://www.mrexcel.com/forum/excel-questions/999321-creating-average-code-all-sheets.html

 

[Jeffrey Mahoney]

Do you have any hidden sheets between the Sheets WEEK11 and MASTER?