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

潘欣柏3273怎么用excel函数在别一个工作表里计算出每个单品每日的销售量? 比如:A列是货号,B列是产品名称,C列是销售数量,D列是日期 要怎么运用公式来求得结果呢? -
卜唯竹13128127248 ______ 你使用SUM函数进行求和即可.

潘欣柏3273excel中怎样计算一段时间的销售数量 -
卜唯竹13128127248 ______ 计算第一个表中起始日到终止日的销售:销售数据在第二个表中 商品名称 销售起始日 销售终止日 销售数量

潘欣柏3273excel表统计不同产品不同日期的合计 -
卜唯竹13128127248 ______ 1. 使用sumif函数即可,C15公式为: =SUMIF($B$2:$B$13,B15,$C$2:$C$13) 2. 下拉填充,如图:

潘欣柏3273EXCEL记录每天的销售额,历史数据
卜唯竹13128127248 ______ 方法一:设一个按钮“保存”,按钮写一个宏实现. 方法二:手工复制粘贴到历史数据表. 方法三:在一个日记表连续记录,再做一个透视表用来查询任意某天、周、月、年的明细或汇总. 上述三种方法任意一种都能满足你的需求.

潘欣柏3273excel累积求和 -
卜唯竹13128127248 ______ 1、以下表为例,求公里数的累加求和; 2、在D2单元格输入=sum($C2$:C2); 3、输入完成后按回车键,然后将鼠标放在在D2单元格右下方,待其成为十字时,按住向下拖动,直至最后一个单元格松开; 4、松开后所有累加求和的结果就出现了.

潘欣柏3273EXCEL 公式设定 如何统计总产量 -
卜唯竹13128127248 ______ 1.如图所示,是销售人员和销售额的列表,我们统计每个销售人员的销售总额.首先我们使用公式里面有一个名称管理器,这里先定义一些需要用到的名称. 2.在名称管理器的左上方有一个新建的按钮,点击新建.然后建立业务员员的名称,...

潘欣柏3273Excel 计算每天的销售金额,合计销售量 -
卜唯竹13128127248 ______ 07版有更全面的方法,不仅可以计算你每天的销售量,还能计算你每种商品的销售量.首先选择数据区域(注意下方和右方要分别多选一行和一列)按F5——特殊——空白,区域里所有的空白单元格会被选中,按住Ctrl键不松,点击“∑”就可以了.

潘欣柏3273excel表格,B列为商品名称,C列为单价,D列 - DW列为某段时间,每天的售出数量,如何算出每天的销售额,谢谢 -
卜唯竹13128127248 ______ 将公式内的单价单元格设为绝对引用试试.$C$2 为绝对引用标志.有问题请 hi 联系.

潘欣柏3273excel如何利用定义名称的方法计算销售量 -
卜唯竹13128127248 ______ 见如图模拟数据,假设分别求1月,2月,3月的总计销量 首先,选择3个月的销量数据区域,【公式】选项下,选择【根据所选内容创建】 选择【首行】,【确定】 这时,我们再在【公式】,【名称管理器】中就可以看到刚刚定义的名称 这时,求每月总计销量就可以直接输入以下公式 一月总计销量: =SUM(一月销量) 二月总计销量: =SUM(二月销量) 三月总计销量: =SUM(三月销量) 以上举例纯粹为解释自定义名称的用法,并不代表是计算销量的最优方法,请周知!

潘欣柏3273excel制表,如何将表格内相同项目进行统计 -
卜唯竹13128127248 ______ 1、用数据透视表,进行相同项目的统计分析. 2、在表格的数据区域,点击任意单元格,顺序按下快捷键alt+d+p键,调出数据透视表向导.点击下一步,系统自动选定数据源区域. 3、直接点击完成,系统将以新建工作表的方式,创建数据透视表. 4、点击字段列表的品名字段,拖动到行区域,点击数量字段拖动到值区域. 5、在值区域,右键——值汇总依据,选择计数,可以对数据由原来的求和改为计数. 6、使用数据透视表,源数据要求是一维表格格式,每列必须具备列标题.