汇总统计表具体做法如下:
1、在电脑上打开表格后,点击数据。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7e3e6709c93d70cf80b16d98eadcd100bba12bd8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、在数据界面,选中需要汇总的表格。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a50f4bfbfbedab64f3398a55e536afc378311ed8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、点击分类汇总。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9f2f070828381f30ff534a3cbb014c086f06f0d9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、选择需要汇总的项目,点击确定。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6c224f4a20a446233e8062f78a22720e0df3d7d9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、自动生成汇总表。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/023b5bb5c9ea15ce62a4279ca4003af33b87b2d9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
总结:
1、打开表格,点击数据。
2、选中需要汇总的表格,点击分类汇总。
3、选择汇总项目,点击确定。
温馨提示:答案为网友推荐,仅供参考
相似回答
excel表格汇总统计怎么做excel表格汇总统计答:1、A | B 1 C200-C2000 | =MID(A2,FINDB("-",A2,1)+2,LEN(A2)-FINDB("-",A2,1))-MID(A2,2,FINDB("-",A2,1)-2)+1 在旁边录入:=MID(A2,FINDB("-",A2,1)+2,LEN(A2)-FINDB("-",A2,1))-MID(A2,2,FINDB("-",A2,1)-2)+1 最后显示1801。2、 ...