解答网友提问。在一个二维表中，如何分组计算值区域中每个值的个数？
我把这题的难度再提高一点，如果行标题还有重复项，如何实现汇总且计数？
案例：
下图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":"cache","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 业绩表，如何统计每个人的各类评分总数？
郎骅柯802EXCEL中怎样统计一列中重复项的个数 -
劳连疤15215207293 ______ =countif(A1:A10,B2) A1:A10数据区域,B2条件,如张三
郎骅柯802EXCEL中如何统计一组数字中重复数字的个数和没有出现的数字 -
劳连疤15215207293 ______ 在B1输入 =row(A1) C1输入 =countif(A$1:A$100,B1) B1、C1向下填充就行了 B列就得到全部序列 C列得到各数字出现的次数,为0的表示没有出现,为1的表示出现1次,大于1的表示重复出现了
郎骅柯802excel统计连续重复值的个数怎么搞? -
劳连疤15215207293 ______ 需要插入顶行,数据从A2开始 C2输入=IF(A2<>A3,COUNT($A$2:$A$100)-SUM(C$1:C1)-COUNT(A3:A$100),＂＂) 公式下拉
郎骅柯802Excel如何统计2列数据中相同数据的个数 -
劳连疤15215207293 ______ =COUNTIF(A:A,＂UA＂)+COUNTIF(B:B,＂UA＂)
郎骅柯802EXCEL如何统计多行相同数据个数 -
劳连疤15215207293 ______ 如果数据在A列,就在B1输入 =COUNTIF(A:A,A1) 确定,向下拉.
郎骅柯802怎样统计Excel表格里一列中众多数据中相同的数据的个数? -
劳连疤15215207293 ______ 假设数据在a1:a6, =sum(1/countif(a1:a6,a1:a6)) 输入后按ctrl+shift+enter录入公式
郎骅柯802怎么用excel统计重复次数 -
劳连疤15215207293 ______ 计算数值在某个区域内的出现频率,然后返回一个垂直数组.例如,使用函数 FREQUENCY 可以在分数区域内计算测验分数的个数.由于函数 FREQUENCY 返回一个数组,所以它必须以数组公式的形式输入. 语法 FREQUENCY(data_array,...
郎骅柯802EXCEL中如何统计一组数字中重复数字的次数? -
劳连疤15215207293 ______ 你的问题不是很明确哦 首先 你得说明你这组数字存在的形式 比如 同一行 每个数字一个单元格 或同一列 每个数字一个单元格 再或 这组数字都在同一单元格内 连续的字符串形式的 还是字符之间有空格 等等 在统计过程中对运用的公式影响很大的 再有 标题问的是重复数字出现的次数吧 可是下面你给出的说明中 给人感觉你要求的结果是 出现一次的数字有哪些 出现两次的数字有哪些 以此类推 要是问次数 是不是这种问法更恰当 数字5出现几次 数字6出现几次 这两种问法有着截然不同的解决思路和办法呢 呵呵 不好意思 别嫌我唠叨 光在这指手画脚的 要想得到及时有效的回答 提问还是尽量要详细 要准确
郎骅柯802Excel如何统计2列数据中相同数据的个数A B UAUA UA UAUA UA UA 如左边数据中如何统计A列、B列同时出现“UA”的次数 -
劳连疤15215207293 ______[答案] =COUNTIF(A:A,＂UA＂)+COUNTIF(B:B,＂UA＂)
郎骅柯802麻烦看下如何在excel中统计一列数值中相同的数值的个数? 帮帮着急的人吧,真心感谢各位了 -
劳连疤15215207293 ______ 在有数据的旁边一例输入以下工式:如数据在A列,在B1列输入以下工式:=COUNTIF(A:A,A1)向下拉