=IF(VLOOKUP($A74,'ADMIN HIDDEN'!$B$2:$D$68,2,FALSE)=1,SUM(INDEX((INDEX(Ex_Data,0,MATCH(VLOOKUP($A74,Time_Sheet_Lookup_Table,3,FALSE),Ex_Data[#Headers],FALSE)))*(Ex_Data[[Macrocycle]:[Macrocycle]]=C$65)*(IF(LEN(C$66),(Ex_Data[[Mesocycle]:[Mesocycle]]=C$66),1)*(IF(LEN(C$67),(Ex_Data[[Week]:[Week]]=C$67),1)*(IF(LEN(C$68),(Ex_Data[[Day]:[Day]]=C$68),1)))),)),IF(VLOOKUP($A74,'ADMIN HIDDEN'!$B$2:$D$68,2,FALSE)=11,SUM(INDEX((INDEX(Day_Data,0,MATCH(VLOOKUP($A74,Time_Sheet_Lookup_Table,3,FALSE),Day_Data[#Headers],FALSE)))*(Day_Data[[Macrocycle]:[Macrocycle]]=C$65)*(IF(LEN(C$66),(Day_Data[[Mesocycle]:[Mesocycle]]=C$66),1)*(IF(LEN(C$67),(Day_Data[[Week]:[Week]]=C$67),1)*(IF(LEN(C$68),(Day_Data[[Day]:[Day]]=C$68),1)))),)),IF(VLOOKUP($A74,'ADMIN HIDDEN'!$B$2:$D$68,2,FALSE)=2,MAX(INDEX((INDEX(Ex_Data,0,MATCH(VLOOKUP($A74,Time_Sheet_Lookup_Table,3,FALSE),Ex_Data[#Headers],FALSE)))*(Ex_Data[[Macrocycle]:[Macrocycle]]=C$65)*(IF(LEN(C$66),(Ex_Data[[Mesocycle]:[Mesocycle]]=C$66),1)*(IF(LEN(C$67),(Ex_Data[[Week]:[Week]]=C$67),1)*(IF(LEN(C$68),(Ex_Data[[Day]:[Day]]=C$68),1)))),)),IF(VLOOKUP($A74,'ADMIN HIDDEN'!$B$2:$D$68,2,FALSE)=3,MIN(INDEX((INDEX(Ex_Data,0,MATCH(VLOOKUP($A74,Time_Sheet_Lookup_Table,3,FALSE),Ex_Data[#Headers],FALSE)))*(Ex_Data[[Macrocycle]:[Macrocycle]]=C$65)*(IF(LEN(C$66),(Ex_Data[[Mesocycle]:[Mesocycle]]=C$66),1)*(IF(LEN(C$67),(Ex_Data[[Week]:[Week]]=C$67),1)*(IF(LEN(C$68),(Ex_Data[[Day]:[Day]]=C$68),1)))),)),IF(VLOOKUP($A74,'ADMIN HIDDEN'!$B$2:$D$68,2,FALSE)=4,SUM(IF(C$65="",1,Ex_Data[[Macrocycle]:[Macrocycle]]=C$65)*IF(C$66="",1,Ex_Data[[Mesocycle]:[Mesocycle]]=C$66)*IF(C$67="",1,Ex_Data[[Week]:[Week]]=C$67)*IF(C$68="",1,Ex_Data[[Day]:[Day]]=C$68)),IF(VLOOKUP($A74,'ADMIN HIDDEN'!$B$2:$D$68,2,FALSE)=5,MROUND(SUMPRODUCT(Protocol_Rep,C_Col_Protocol_Rep)/SUM(C_Col_Protocol_Rep),0.1),IF(VLOOKUP($A74,'ADMIN HIDDEN'!$B$2:$D$68,2,FALSE)=51,MROUND(AVERAGE(INDEX((INDEX(Day_Data,0,MATCH(VLOOKUP($A74,Time_Sheet_Lookup_Table,3,FALSE),Day_Data[#Headers],FALSE)))*(Day_Data[[Macrocycle]:[Macrocycle]]=C$65)*(IF(LEN(C$66),(Day_Data[[Mesocycle]:[Mesocycle]]=C$66),1)*(IF(LEN(C$67),(Day_Data[[Week]:[Week]]=C$67),1)*(IF(LEN(C$68),(Day_Data[[Day]:[Day]]=C$68),1)))),)),0.1),IF(VLOOKUP($A74,'ADMIN HIDDEN'!$B$2:$D$68,2,FALSE)=511,MROUND(SUMPRODUCT(Scale_1_To_5,C_Col_Session_RPE)/SUM(C_Col_Session_RPE),0.1),IF(VLOOKUP($A74,'ADMIN HIDDEN'!$B$2:$D$68,2,FALSE)=512,MROUND(SUMPRODUCT(Scale_1_To_5,C_Col_Readiness_Rating)/SUM(C_Col_Readiness_Rating),0.1),IF(VLOOKUP($A74,'ADMIN HIDDEN'!$B$2:$D$68,2,FALSE)=513,MROUND(SUMPRODUCT(Scale_1_To_5,C_Col_Quality_of_Session)/SUM(C_Col_Quality_of_Session),0.1),IF(VLOOKUP($A74,'ADMIN HIDDEN'!$B$2:$D$68,2,FALSE)=52,MROUND(SUMPRODUCT(Protocol_RI,C_Col_Protocol_RI)/SUM(C_Col_Protocol_RI),0.1),IF(VLOOKUP($A74,'ADMIN HIDDEN'!$B$2:$D$68,2,FALSE)=53,MROUND(SUMPRODUCT(Protocol_RPE,C_Col_Protocol_RPE)/SUM(C_Col_Protocol_RPE),0.1),IF(VLOOKUP($A74,'ADMIN HIDDEN'!$B$2:$D$68,2,FALSE)=6,MROUND(SUMPRODUCT(RT_Values,C_Col_Avg_RT)/SUM(C_Col_Avg_RT),0.1),IF(VLOOKUP($A74,'ADMIN HIDDEN'!$B$2:$D$68,2,FALSE)=7,MROUND(SUMPRODUCT(Intensity_Values,C_Col_Avg_Int)/SUM(C_Col_Avg_Int),0.01),IF(VLOOKUP($A74,'ADMIN HIDDEN'!$B$2:$D$68,2,FALSE)=8,MROUND(SUMPRODUCT(RPE_Values,C_Col_Avg_RPE)/SUM(C_Col_Avg_RPE),0.1),IF(VLOOKUP($A74,'ADMIN HIDDEN'!$B$2:$D$68,2,FALSE)=9,MROUND(SUM(INDEX((INDEX(Ex_Data,0,27))*(Ex_Data[[Macrocycle]:[Macrocycle]]=C$65)*(IF(LEN(C$66),(Ex_Data[[Mesocycle]:[Mesocycle]]=C$66),1)*(IF(LEN(C$67),(Ex_Data[[Week]:[Week]]=C$67),1)*(IF(LEN(C$68),(Ex_Data[[Day]:[Day]]=C$68),1)))),))*SUMPRODUCT(Intensity_Values,C_Col_Avg_Int)/SUM(C_Col_Avg_Int),1),IF(VLOOKUP($A74,'ADMIN HIDDEN'!$B$2:$D$68,2,FALSE)=10,SUMPRODUCT(((Ex_Data[[Macrocycle]:[Macrocycle]]=C$65)+(C$65=""))*((Ex_Data[[Mesocycle]:[Mesocycle]]=C$66)+(C$66=""))*((Ex_Data[[Week]:[Week]]=C$67)+(C$67=""))*((Ex_Data[[Day]:[Day]]=C$68)+(C$68=""))*ISNUMBER(SEARCH(VLOOKUP($A74,PR_Lookup_Table,3,FALSE),IF(OR($A74="All Time PRs, est.",$A74="All Time PRs, missed",$A74="All Time PRs, new"),Ex_Data[[All Time PR]:[All Time PR]],Ex_Data[[Protocol PR]:[Protocol PR]])))))))))))))))))))))

4086 characters not counting the curly brackets. Basically it looks up a row label and returns the data that corresponds with the appropriate time unit column labels.