如果要按地区汇总,建议补齐地区列数据,如图:
将公式
=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)
方法同上,效果如图:
温馨提示:答案为网友推荐,仅供参考