方法有很多:函数公式;数据透视表;分类汇总。。。自己根据需求做就行
1. 函数公式
=SUMIF($A$2:$A$13,D2,$B$2:$B$13)
如图:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/023b5bb5c9ea15ce8e55446cb9003af33a87b218?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
函数公式
2. 数据透视表
选择数据源,【插入】-【数据透视表】-【选择放置透视表的位置】两个选项任选一个(本例选择现有工作表)-将字段【word】拖放到【行】标签,字段【count】拖放到【值】标签就ok了
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d62a6059252dd42a9935a6ce0c3b5bb5c9eab893?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
透视表
3. 分类汇总
在进行分类汇总前先对数据排序(选择数据后,依次【数据】-【排序】-【扩展选定区域】,主关键字【word】)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a686c9177f3e6709d55de29a34c79f3df8dc5571?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
排序
排序完成后,选择数据源,选择功能菜单【数据】-【分类汇总】,再按截图设置即可
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/023b5bb5c9ea15ce80d2466cb9003af33a87b293?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
分类汇总设置
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d50735fae6cd7b89dc429ce6002442a7d9330eac?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
分类汇总结果