For some reason when I move this to my actual sheet i'm getting a invalid cell reference error. I'm typing the first formula into B4 which is week #1. When I trace the error it points to the cell that says the team name. "C2"

=IF(COUNTIF(INDIRECT("Week"&ROW()-2&"!$N$24:$N$39"),C$2)=0,"",COUNTIF(INDIRECT("Week"&ROW()-2&"!$N$24:$N$39"),C$2))