在D1中输入=IF(AND(COUNTIF(F:F,A1),B1="英语",C1="北京"),"对","错")下拉填充。
D1公式下拉：
=IF(A1="","",IF(COUNTIF(F:F,A1)*(B1="英语")*(C1="北京"), "对","错"))
