=SUMPRODUCT((v:v=66)*(W:W=23.5)*d:d)你用的07版以上的也可以用=SUMIFS(D:D,v:v,66,W:W,23.5)
=SUMPRODUCT(($V$7:$V$30=66)*($W$7:$W$30=23.5)*$D$7:$D$30)
=SUMPRODUCT((V$7:V$999=66)*(W$7:W$999=23.5)*D$7:D$999)
