Create a list of the cells used in a COUNTIFS formula

Try:

Formula:

=SUBSTITUTE(TRIM(IF(AND(A1>=1,A1<=5),A1,"")&" "&IF(AND(B1>=1,B1<=5),B1,"")&" "&IF(AND(C1>=1,C1<=5),C1,"")&" "&IF(AND(D1>=1,D1<=5),D1,"")&" "&IF(AND(E1>=1,E1<=5),E1,"")&" "&IF(AND(F1>=1,F1<=5),F1,"")&" "&IF(AND(G1>=1,G1<=5),G1,"")&" "&IF(AND(H1>=1,H1<=5),H1,"")&" "&IF(AND(I1>=1,I1<=5),I1,"")&" "&IF(AND(J1>=1,J1<=5),J1,""))," ",",")

copied down, where A1:J1 contains first set.