I’ve never used the "Indirect" formula before and I’m struggling to write this into my current formula. I have an “Sum(If(“ array formula and I’m trying to make it more dynamic by having the formula select the correct tab (Tabs are labeled by Day of the week) to pull the data from. I have a cell that updates everyday with the current day of the week in cell A4. I will need to be able to drag this formula to the other cells within my work sheet. Here is my current formula:

{=SUM(IF(Sunday!$A$7:$A$4954=$A7,IF(Sunday!E$7:E$4954=0,1,0),0))/COUNTIF(Sunday!$A$7:$A$4954,$A7)}

I’m trying to make the tab reference (in this case “Sunday”) dynamic. I’ve tried adding the indirect to the formula with no success. Please help.

{=SUM(IF(INDIRECT($A$4&"!$A$7:$A$4954=$A7"),IF(INDIRECT($A$4&"!E$7:E$4954=0,1,0),0))")/COUNTIF(INDIRECT($A$4&"!$A$7:$A$4954,$A7)"}