记两个EXCEL多表查重公式
=SUMPRODUCT(COUNTIF(INDIRECT("'11单元试题模板:11单元试题模板'!B1:B4"),"excel")) =SUMPRODUCT(COUNTIF(INDIRECT("'"&Q3:Q8&"'!F2:F41"),F2))
=SUMPRODUCT(COUNTIF(INDIRECT("'11单元试题模板:11单元试题模板'!B1:B4"),"excel")) =SUMPRODUCT(COUNTIF(INDIRECT("'"&Q3:Q8&"'!F2:F41"),F2))