Hi,
I am using a SUM PRODUCT formula in a spreadsheet that is being use to reference 20 different people time sheet stored in one folder but 20 different worksheet.
This works fine and i copy the master sheet into a new folder and as people save there files it updates.
My problem is that if some one does not put there work in the master will show last month data is there any way of making it update so it would show error or 0 when a sheet missing?
Basically i would like to force the Sum product to update so it will show 0 or error until people save there monthly sheet in the folder
e.g =SUMPRODUCT(--('S:\Web DesignTimesheets\June Monthly Team\[Carl_Monthly_stats.xlsx]June Time Sheet'!$B:$B=$B7)*--('S:\Web Design\June Monthly Team\[Carl_Monthly_stats.xlsx]June Time Sheet'!$G:$G=$C$5)*('S:\Web Design\June Monthly Team\[Carl_Monthly_stats.xlsx]June Time Sheet'!$I:$I<>""))
I am using a SUM PRODUCT formula in a spreadsheet that is being use to reference 20 different people time sheet stored in one folder but 20 different worksheet.
This works fine and i copy the master sheet into a new folder and as people save there files it updates.
My problem is that if some one does not put there work in the master will show last month data is there any way of making it update so it would show error or 0 when a sheet missing?
Basically i would like to force the Sum product to update so it will show 0 or error until people save there monthly sheet in the folder
e.g =SUMPRODUCT(--('S:\Web DesignTimesheets\June Monthly Team\[Carl_Monthly_stats.xlsx]June Time Sheet'!$B:$B=$B7)*--('S:\Web Design\June Monthly Team\[Carl_Monthly_stats.xlsx]June Time Sheet'!$G:$G=$C$5)*('S:\Web Design\June Monthly Team\[Carl_Monthly_stats.xlsx]June Time Sheet'!$I:$I<>""))
