假设上表为sheet1表,在sheet2表输入公式:
a1
=index(sheet1!a:a,small(if(match(sheet1!a$1:a$100&"",sheet1!a$1:a$100&"",)=row($1:$100),row($1:$100),4^8),row(1:1)))&""
b1
=sumif(sheet1!a:a,a1,sheet1!b:b)
c1
=sumproduct((sheet1!a$1:a$100=a1)*sheet1!b$1:b$100*sheet1!c$1:c$100)
选择a1:c1,下拉填充
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024