Excel如何使用countif函数进行多表格统计？

日期：2019-10-20 18:44:03 人气：1

=SUM(COUNTIFS(INDIRECT(ROW(1:50)&"!C:C"),">=17",INDIRECT(ROW(1:50)&"!C:C"),"<=210",INDIRECT(ROW(1:50)&"!D:D"),"银镜实验")) 你自己在修改下对应的区域吧