记两个EXCEL多表查重公式

=SUMPRODUCT(COUNTIF(INDIRECT("'11单元试题模板:11单元试题模板'!B1:B4"),"excel"))


=SUMPRODUCT(COUNTIF(INDIRECT("'"&Q3:Q8&"'!F2:F41"),F2))