条件求和函数

yating_vip

多条件求和，求助求助，谢谢

苏Lang

1. =(SUMPRODUCT((MONTH($A$3:$A$26)=COLUMN(B1))*($D$3:$D$26=$G3)*$C$3:$C$26)+SUMPRODUCT((MONTH($A$3:$A$26)=COLUMN(B1))*(ISNUMBER(FIND($G3,$D$3:$D$26)))*$C$3:$C$26))/2

复制代码

yating_vip

苏Lang 发表于 2023-3-19 11:01

有没有简单一点的

祝洪忠-

1. =SUM($C$3:$C$26/MMULT(ISNUMBER(FIND(TRANSPOSE($G$3:$G$9),$D$3:$D$26))*1,1^ROW($1:$7))*ISNUMBER(FIND($G3,$D$3:$D$26))*(TEXT($A$3:$A$26,"m月")=H$2))

复制代码

我的城市你来过

=SUM(SUMPRODUCT(((MONTH($A$3:$A$26)=MID(J$2,1,1)*1)*(LEN($D$3:$D$26)=LEN($G3))*($D$3:$D$26=$G3))*$C$3:$C$26),IF((MONTH($A$3:$A$26)=MID(J$2,1,1)*1)*(LEN($D$3:$D$26)>LEN($G3))*(IFERROR(FIND($G3,$D$3:$D$26),0))>0,$C$3:$C$26/2,0))