I have this formula that another user here created for me, basically it counts cells between 2 reference points, just wondering how i may have it just count the non blank cells.
=IF(Data!AS1="","",MATCH("?*",INDEX(Data!AS:AS,1+MATCH(Data!AT1,Data!AS:AS,0)):Data!AS$1048576,0))
=IF(Data!AS1="","",MATCH("?*",INDEX(Data!AS:AS,1+MATCH(Data!AT1,Data!AS:AS,0)):Data!AS$1048576,0))