excel中分类统计问题
来源:学生作业帮 编辑:大师作文网作业帮 分类:综合作业 时间:2024/09/22 10:06:46
excel中分类统计问题
Ax200 Bx100 Cy100 Dy50 Ax200 Bx100 Cy100 Dy50 Ax200 Bx100 Cy100 Dy50 统计A的总量(X:25%C,Y:35%C) 统计B的总量(X:25%C,Y:35%C)
请给出统计A总量的公式:当B列为x时,C取25%,当B为y时C取35%.
A的总量:
=SUMIFS(C1:C12,A1:A12,"A",B1:B12,"x")*0.25+SUMIFS(C1:C12,A1:A12,"A",B1:B12,"y")*0.35
B
的总量:
=SUMIFS(C1:C12,A1:A12,"B",B1:B12,"x")*0.25+SUMIFS(C1:C12,A1:A12,"B",B1:B12,"y")*0.35
=SUMIFS(C1:C12,A1:A12,"A",B1:B12,"x")*0.25+SUMIFS(C1:C12,A1:A12,"A",B1:B12,"y")*0.35
B
的总量:
=SUMIFS(C1:C12,A1:A12,"B",B1:B12,"x")*0.25+SUMIFS(C1:C12,A1:A12,"B",B1:B12,"y")*0.35