如果要按地区汇总,建议补齐地区列数据,如图:将公式=SUMPRODUCT((Sheet1!$B$2:$B$8=$B2)*(Sheet1!$C$2:$C$8=$C2)*Sheet1!D$2:D$8)+SUMPRODUCT((Sheet2!$B$2:$B$8=$B2)*(Sheet2!$C$2:$C$8=$C2)*Sheet2!D$2:D$8)复制后粘贴到“D2”单元格,对准右下角,光标成“+”状时双击,如图:再接着向右拖,如图:如果不按地区汇总,公式为:=SUMIF(Sheet1!$C:$C,$C2,Sheet1!D:D)+SUMIF(Sheet2!$C:$C,$C2,Sheet2!D:D)方法同上,效果如图:
温馨提示:答案为网友推荐,仅供参考