EXCEL分类加权求和A列 B列 C列1 a\x052\x056.32 a\x053\x056.43 a\x0515\x056.74 b\x053\x057.15 b\x056\x057.66 b\x057\x057.957 b\x058\x058.358 k\x051\x058.759 k\x059\x059.1510 l\x0513\x059.5511 l\x0512\x059.9512 l\x055\x0510.3513 l\x056\x0510.751

EXCEL分类加权求和A列 B列 C列1 a\x052\x056.32 a\x053\x056.43 a\x0515\x056.74 b\x053\x057.15 b\x056\x057.66 b\x057\x057.957 b\x058\x058.358 k\x051\x058.759 k\x059\x059.1510 l\x0513\x059.5511 l\x0512\x059.9512 l\x055\x0510.3513 l\x056\x0510.751
EXCEL分类加权求和
A列 B列 C列
1 a\x052\x056.3
2 a\x053\x056.4
3 a\x0515\x056.7
4 b\x053\x057.1
5 b\x056\x057.6
6 b\x057\x057.95
7 b\x058\x058.35
8 k\x051\x058.75
9 k\x059\x059.15
10 l\x0513\x059.55
11 l\x0512\x059.95
12 l\x055\x0510.35
13 l\x056\x0510.75
14 l\x057\x0511.15
现在要求在D列返回B列*C列加权求和/C列的结果,条件是根据A列数据进行判断,例如A列是a的,则返回值d1=(c1*b1+c2*b2+c3*b3)/c1;d2=(c1*b1+c2*b2+c3*b3)/c2;再如,A列是k的,则返回值d8=(c8*b8+c9*b9)/c8
d1=(c1*b1)/(c1*b1+c2*b2+c3*b3)*（c1+c2+c3)
d2=(c2*b2)/(c1*b1+c2*b2+c3*b3)*（c1+c2+c3)
d8=(c8*b8)/(c8*b8+c9*b9)*(c8+c9)
上面求和,我用sumif函数,A列是a的时候还是对的,公式拉到下一个就有点问题了.

EXCEL分类加权求和A列 B列 C列1 a\x052\x056.32 a\x053\x056.43 a\x0515\x056.74 b\x053\x057.15 b\x056\x057.66 b\x057\x057.957 b\x058\x058.358 k\x051\x058.759 k\x059\x059.1510 l\x0513\x059.5511 l\x0512\x059.9512 l\x055\x0510.3513 l\x056\x0510.751
d1输入
=sumproduct((a$1:a$14=a1)*b$1:b$14*c$1:c$14)/c1
双击填充柄