Alternative to INDIRECT in COUNTIF formula

Ciao,

you could substitute INDIRECT segments with

INDEX(Data!$A$4:$CW$1048576,,MATCH($N$2,Data!A$3:CW$3,0))

=((COUNTIFS(INDEX(Data!$A$4:$CW$1048576,,MATCH($N$2,Data!A$3:CW$3,0)),"1",RAutumn,"EXS")+COUNTIFS(INDEX(Data!$A$4:$CW$1048576,,MATCH($N$2,Data!$A$3:$CW$3,0)),"1",RAutumn,"GDS")))/COUNTIF(INDEX(Data!$A$4:$CW$1048576,,MATCH($N$2,Data!$A$3:$CW$3,0)),"1")

Hope it helps