记两个EXCEL多表查重公式

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


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

 

posted on 2020-10-13 09:56  静以修身俭以养德  阅读(499)  评论(0编辑  收藏  举报

导航