Hi all,

Is there a less volatile alternative to INDIRECT(Lists!J1) to retrieve the text from cell Lists!J1 in the COUNTIFS formula below?

=((COUNTIFS(INDIRECT(Lists!J1),"1",RAutumn,"EXS")+(COUNTIFS(INDIRECT(Lists!J1),"1",RAutumn,"GDS"))))/COUNTIF(INDIRECT(Lists!J1),"1")

Many thanks.