您好 如何将D11=IF(SUMPRODUCT(1/COUNTIF(C11:C17,C11:C17))=4,"a",""

您好 如何将D11=IF(SUMPRODUCT(1/COUNTIF(C11:C17,C11:C17))=4,"a","") 区域等差 适用于C18：C24等等
=IF(AND(COUNTIF(INDIRECT("C"&7+ROW(A1)*4):INDIRECT("C"&10+ROW(A1)*4),0)=1,COUNTIF(INDIRECT("C"&7+ROW(A1)*4):INDIRECT("C"&10+ROW(A1)*4),INDIRECT("C"&7+ROW(A1)*4):INDIRECT("C"&10+ROW(A1)*4))=1),"a","")
我依据您之前给的这个公式 进行改写 =IF(SUMPRODUCT(1/COUNTIF(INDIRECT("C"&4+ROW(A1)*7):INDIRECT("C"&10+ROW(A1)*7),INDIRECT("C"&4+ROW(A1)*7):INDIRECT("C"&10+ROW(A1)*7)))=4,"a","")
改写后的公式,是错误的 如何改写成正确的