把公式改成如下即可：=SUMIFS([shujuyuan.xls]总数据!I:I,[shujuyuan.xls]总数据!E:E,B14,[shujuyuan.xls]总数据!A:A,">="&$L$1,[shujuyuan.xls]总数据!A:A,"<="&$N$1,[shujuyuan.xls]总数据!F:F,C14)
