解答网友提问。在一个二维表中，如何分组计算值区域中每个值的个数？
       我把这题的难度再提高一点，如果行标题还有重复项，如何实现汇总且计数？
       案例：
       下图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 业绩表，如何统计每个人的各类评分总数？

阎善耐1072excel 如何在一个表格里统计出类型一样且总数的方式 -
政艺婷17311314877 ______ 在SHEET2的A2单元格输入:DA00000 在SHEET2的B2单元格输入=SUM(IF(Sheet1!A$2:A$17=A2,Sheet1!B$2:B$17),0)→同时按住“CTRL+SHIFT”键回车确定→类型为“DA00000”的合计数即可显示在SHEET2 B2单元格 如果要统计类型为“DA11111 ”或者其它类型的合计数,只要在SHEET2 B2单元格改变类型即可. 如果想把各种类型的都统计出来,那,在SHEET2的A3、A4、A5等单元格向下输入各类型名称,然后把SHEET2的B2单元格公式向下拖动复制就可以了.

阎善耐1072Excel表格如何统计某一列为同一种类型的收支总数? -
政艺婷17311314877 ______ 收入公式等于=sumif(E:E,$E$39,G:G) 支出公式等于=sumif(E:E,$E$39,H:H)

阎善耐1072急!如何将excel表格按类汇总求和 -
政艺婷17311314877 ______ 把6张表合并成一个工作簿,注意是工作簿,不是工作表,一个工作簿可以包含很多工作表,然后用公式:=表名1!SUM(A1:A11)+表名2!SUM(A1:A11)+表名3!SUM(A1:A11) 即可 原来你是要求按类汇总求和,那就要全部复制到一张表中,然后先排序,再用数据/分类汇总了,如果懂ACCESS数据库,则更简单,把数据导入ACCESS,然后建一个查询即可

阎善耐1072EXCLE统计某列区间数据总和例如,A列是1 - 99等级,B列是1 - 99各级升级所需经验.需要在C1填入当前等级,D1填入目标等级,E1计算出总共所需经验. -
政艺婷17311314877 ______[答案] 使用公式: =SUMPRODUCT((A$1:A$99

阎善耐1072电子表格怎样求总和? -
政艺婷17311314877 ______ 1. 首先打开excel表格. 2.输入一列数据. 3.假设第A列,第12行存放第A列,前11行之和.首先选中该框. 4.点击操作栏中【公式】. 5.点击【自动求和】. 6.然后按回车键.求和完毕. 扩展资料: 电子表格可以输入输出、显示...

阎善耐1072EXCEL表格中怎样求一列数据的总和?? -
政艺婷17311314877 ______ 上面有一个求和符号∑点它就可以了

阎善耐1072excel怎样计算某一类数据的和,例如A1 - A20是项目名,B1 - B20对应的项目数值,怎么计算A1 - A20中相同的项的和 -
政艺婷17311314877 ______ C1 =SUMIF(A$1:A$20,A1,B$1:B$20) 公式下拉.

阎善耐1072excel想统计两个重复名称的总和一共是多少,怎么统计,想统计A和b的总和一共是多少,怎么统计,A 42 b 52 c 65 A 42b 25 c 65 A 26 b 53 c 6 A 23b 35c ... -
政艺婷17311314877 ______[答案] 假设你给的数据在a:b列 =sum(sumif(a:a,{＂a＂,＂b＂},b:b))

阎善耐1072EXcel如何统计某日某物的总和 -
政艺婷17311314877 ______ 假如A列为日期,B列为物品名称,C列为数量,那么可以用公式:=sumproduct((A:A=＂具体日期＂)*(B:B=＂物品名称＂)*C:C) 计算总和.

阎善耐1072excel数据的求和功能:给出一个总和,我如何能将很多数据中的各别数据挑出来直接得出所给的总和 -
政艺婷17311314877 ______ 可以: 在状态栏中,鼠标右键,选择求和. 再按住:SHIFT的同时,用鼠标左键去选择要求和的单元格,状态栏中自动求出你选择数字和和了.