解答网友提问。在一个二维表中，如何分组计算值区域中每个值的个数？
我把这题的难度再提高一点，如果行标题还有重复项，如何实现汇总且计数？
案例：
下图1是各员工的业绩得分表，其中的姓名有不规律的重复项。
请计算出每个人各项评分的总数，效果如下图2、3所示。
解决方案1：
1.按Alt+D+P -->在弹出的对话框中选择“多重合并计算数据区域”-->点击“下一步”
2.点击“下一步”。
3.选中整个数据表区域 -->点击“添加”按钮 -->点击“下一步”
4.选择“现有工作表”及所需放置的位置 -->点击“完成”
默认的数据透视表是这样的。
5.将“列”和“值”的字段对调一下。
6.点开“列标签”旁边的箭头 -->在弹出的菜单中取消勾选“(空白)”-->点击“确定”
这就是想要的结果。
解决方案2：
1. 选中数据表的任意单元格 -->选择菜单栏的“数据”-->“从表格”
2.在弹出的对话框中保留默认设置 -->点击“确定”
表格已经上传至PowerQuery。
3.选中“姓名”列 -->选择菜单栏的“转换”-->“逆透视列”-->“逆透视其他列”
4.删除“属性”列。
5.选择菜单栏的“添加列”-->“自定义列”
6.在弹出的对话框的公式处输入“1”-->点击“确定”
7.选中“值”列 -->选择菜单栏的“转换”-->“透视列”
8.在弹出的对话框的下拉菜单中选择“自定义”-->点击“确定”
9.通过拖动将列按字母顺序排列。
10.选择菜单栏的“主页”-->“关闭并上载”-->“关闭并上载至”
11.在弹出的对话框中选择“表”-->选择“现有工作表”及所需上传至的位置 -->点击“加载”
右侧绿色的表格就是最终统计结果。
","gnid":"9d4202dceed344b51","img_data":[{"flag":2,"img":[{"desc":"","height":"278","title":"","url":"https://p0.ssl.img.360kuai.com/t01e635d8b322dfe603.jpg","width":"787"},{"desc":"","height":"215","title":"","url":"https://p0.ssl.img.360kuai.com/t0178f38611bee34cfa.jpg","width":"273"},{"desc":"","height":"190","title":"","url":"https://p0.ssl.img.360kuai.com/t01b42fc3bb0960b5f8.jpg","width":"208"},{"desc":"","height":"379","title":"","url":"https://p0.ssl.img.360kuai.com/t01218d846f96ea5db2.jpg","width":"385"},{"desc":"","height":"268","title":"","url":"https://p0.ssl.img.360kuai.com/t0127df58af6895fa4f.jpg","width":"407"},{"desc":"","height":"323","title":"","url":"https://p0.ssl.img.360kuai.com/t015279ea0857f25b08.jpg","width":"359"},{"desc":"","height":"255","title":"","url":"https://p0.ssl.img.360kuai.com/t014f4a5921ff963d94.jpg","width":"517"},{"desc":"","height":"714","title":"","url":"https://p0.ssl.img.360kuai.com/t0127f68b39664fb974.jpg","width":"350"},{"desc":"","height":"296","title":"","url":"https://p0.ssl.img.360kuai.com/t0183d126daecb7edc4.jpg","width":"843"},{"desc":"","height":"708","title":"","url":"https://p0.ssl.img.360kuai.com/t018e1728d3770ef44f.jpg","width":"348"},{"desc":"","height":"297","title":"","url":"https://p0.ssl.img.360kuai.com/t017f83d61a17aaa608.jpg","width":"347"},{"desc":"","height":"393","title":"","url":"https://p0.ssl.img.360kuai.com/t01b0cf8b81f72961c7.jpg","width":"441"},{"desc":"","height":"215","title":"","url":"https://p0.ssl.img.360kuai.com/t0178f38611bee34cfa.jpg","width":"273"},{"desc":"","height":"225","title":"","url":"https://p0.ssl.img.360kuai.com/t014892e5e5a2307de4.jpg","width":"325"},{"desc":"","height":"98","title":"","url":"https://p0.ssl.img.360kuai.com/t01642e771be57bc0e1.jpg","width":"214"},{"desc":"","height":"241","title":"","url":"https://p0.ssl.img.360kuai.com/t01e7d443e4c1b8a8e2.jpg","width":"1200"},{"desc":"","height":"429","title":"","url":"https://p0.ssl.img.360kuai.com/t01dc0eaede0e8e306e.jpg","width":"564"},{"desc":"","height":"785","title":"","url":"https://p0.ssl.img.360kuai.com/t019a809013fe967de1.jpg","width":"290"},{"desc":"","height":"959","title":"","url":"https://p0.ssl.img.360kuai.com/t01e1274045c44313f8.jpg","width":"414"},{"desc":"","height":"776","title":"","url":"https://p0.ssl.img.360kuai.com/t01d81fc0528025aaac.jpg","width":"199"},{"desc":"","height":"152","title":"","url":"https://p0.ssl.img.360kuai.com/t015d0e58ef4c3f0296.jpg","width":"320"},{"desc":"","height":"395","title":"","url":"https://p0.ssl.img.360kuai.com/t01508fd43592a7ca5f.jpg","width":"702"},{"desc":"","height":"782","title":"","url":"https://p0.ssl.img.360kuai.com/t01dfa09600b1f345c3.jpg","width":"294"},{"desc":"","height":"971","title":"","url":"https://p0.ssl.img.360kuai.com/t011019f4d04883d03e.jpg","width":"396"},{"desc":"","height":"224","title":"","url":"https://p0.ssl.img.360kuai.com/t015afacf5144b13654.jpg","width":"702"},{"desc":"","height":"179","title":"","url":"https://p0.ssl.img.360kuai.com/t01e236b638cff0bb6c.jpg","width":"359"},{"desc":"","height":"180","title":"","url":"https://p0.ssl.img.360kuai.com/t01b302d0790f4e9265.jpg","width":"359"},{"desc":"","height":"135","title":"","url":"https://p0.ssl.img.360kuai.com/t01e15a1582d5b663f3.jpg","width":"193"},{"desc":"","height":"328","title":"","url":"https://p0.ssl.img.360kuai.com/t015df78d49ef3823e9.jpg","width":"402"},{"desc":"","height":"279","title":"","url":"https://p0.ssl.img.360kuai.com/t01e0f06fb17fdb6422.jpg","width":"1172"}]}],"original":0,"pat":"art_src_0,fts0,sts0","powerby":"pika","pub_time":1712657822000,"pure":"","rawurl":"http://zm.news.so.com/8a87f18e7fa9ac9fed77250450da8e79","redirect":0,"rptid":"21148dd07e7cc31e","rss_ext":[],"s":"t","src":"潘可弟","tag":[{"clk":"keconomy_1:excel","k":"excel","u":""}],"title":"值区域是文本的 Excel 业绩表，如何统计每个人的各类评分总数？
韦宏路1402如何将Excel表格插入另一Excel表格
寇伦虽19179821729 ______ 运行Excel2000,在“工具”菜单中选中“自定义”项.选择“命令”选项卡,在“类别”中选择“工具”,再在命令中选择“摄影”拖动到“格式栏”. 应用:在Sheet1中制作一张底表格,在Sheet2中制作需要插入的表格.选择要插入的部分,点击“摄影”;然后选择Sheet1,将十字光标移动到待插入的位置,单击.OK!
韦宏路1402如何把Excel薄中的一张表放到另一薄中? -
寇伦虽19179821729 ______ 首先两个文件都要打开,在需要复制的文件里面,下面工作表名的地方点右键,比如在Sheet1上点右键,选移动或复制,这时候会弹出一个对话框,勾上建立副本的复选框,在工作薄下拉框中选你需要粘贴到的excel文件,然后制定需要复制的位置,点确定就可以了.你随便找两个表试试就知道了.
韦宏路1402excel怎么插入excel表格 -
寇伦虽19179821729 ______ 这个真不行.只有不同的应用程序之间才可能.如果是excel表之间,直接链接就好了啊.
韦宏路1402怎样把EXCEL表格放入文件夹? -
寇伦虽19179821729 ______ 方法有很多2113种: 1、“单击”选中5261不放,可以拖入指定文件夹. 2、选中表格文件后,4102“右击”选则“复制”1653(或“剪切”),再来到指定文件夹“右击”,选则“粘贴”. 3、选中表格文件后,使用快捷键“ctrl+c”,再来到指定文件夹,使用快捷键“ctrl+v”.
韦宏路1402请问Excel制作的表格怎么放在指定的区域内? -
寇伦虽19179821729 ______ 你是不是想把EXCEL放在WORD里呀?如果这样,可以用在WORD里的“插入”-----“对象”-----“由文件创建”来引用已经存在的EXCEL,或者在“新建类型”里加入“excel工作表”,这样在WORD里制定的位置里就增加了一个excel图表了,这个图表可以用excel编辑,大小和位置可以用四面的边框来定位.
韦宏路1402在excel表格中怎样插入原先的表格 -
寇伦虽19179821729 ______ 打开需要插入对象文件的Excel表格,如下图所示. 用鼠标单击要插入对象文件单元格,然后依次点击＂插入＂菜单--＂对象＂,窗口会自动弹出＂对象＂对话框,如下图所示. 在＂对象＂对话框中选择＂由文件创建＂选项卡,单击＂浏览＂,...
韦宏路1402请问怎样才能把一个完整文件放到EXCEL表格中? -
寇伦虽19179821729 ______ 单元格设置,合并单元格,然后就可以把一个完整文件放到表格中了.
韦宏路1402怎么让excel里面所有的文件在一个表里面 -
寇伦虽19179821729 ______ 我们需要把多个excel表都放在同一个文件夹里面,并在这个文件夹里面新建一个excel.如图所示: 用microsoft excel打开新建的excel表,并右键单击sheet1,找到“查看代码”,单击进去.进去之后就看到了宏计算界面.如图所示: 然后我们...
韦宏路1402怎样将EXCEL表中几个单元格的内容放入一个单元格内
寇伦虽19179821729 ______ 用&符号连接单元格即可,如:A1=苹果,B1=apple,则C1可写入公式将A和B的内容合起来=A1&B1,即C1将显示为“苹果apple＂.如果有更多单元格,再增加&符号即可.
韦宏路1402excel表格怎么放进word文档 -
寇伦虽19179821729 ______ 首先,在excel中操作好我们的目的表格,即使在excel表格中,制表,输入数据,对数据进行相关操作.完成该操作之后,选定我们所要的表格内容,进行复制,只要选择【Ctrl+C 其次,切换到word中,在菜单栏中找到,【文件】--【粘贴】--【选择性粘贴】.之后会跳出一个【选择性粘贴】对话框,在该界面中,选择【粘贴】选项,然后再选择【Microsoft Excel 工作表 对象】.最后单击【确定】.3 最后,上一个效果图,在word中的表格是不是和在excel表格中的一模一样呢.