最简单的就是表1和表2粘贴到一起，然后使用sumif函数来汇总就好了
第一种情况可以选中所有数据然后按快捷键alt+=就可以啦！第二种情况是合并单元格求和可以看以下视频{!-- PGC_VIDEO:{"thumb_height": 840, "vposter": "http://p1.toutiaoimg.com/origin/2eee3000bd905e42c38ed "thumb_width": 948, "vid": "v02016e90000boi0juaiv574kfls0cm0 "vu": "v02016e90000boi0juaiv574kfls0cm0 "duration": 120.27, "thumb_url": "2eee3000bd905e42c38ed "thumb_uri": "2eee3000bd905e42c38ed "video_size": {"high": {"duration": 120.27, "h": 840, "w": 948}, "ultra": {"duration": 120.27, "h": 840, "w": 948}, "normal": {"duration": 120.27, "h": 840, "w": 948}}} --}第三种情况是隔列求和可以下面视频{!-- PGC_VIDEO:{"thumb_height": 660, "vposter": "http://p1.toutiaoimg.com/origin/2eeeb000e2393928c461a "thumb_width": 1174, "vid": "v020160a0000boi0lv3rm1n0n28bh3f0 "vu": "v020160a0000boi0lv3rm1n0n28bh3f0 "duration": 96.03, "thumb_url": "2eeeb000e2393928c461a "thumb_uri": "2eeeb000e2393928c461a "video_size": {"high": {"duration": 96.03, "h": 660, "w": 1174}, "ultra": {"duration": 96.03, "h": 660, "w": 1174}, "normal": {"duration": 96.03, "h": 660, "w": 1174}}} --}最后希望可以帮到你，谢谢！
