求教条件求和函数

小白YYT

求助，多条件求和函数，谢谢！

cutecpu

表二公式:
=SUM((MONTH($A$3:$A$26)=COLUMN(B1))*ISNUMBER(FIND($G3,$D$3:$D$26))*(1-(LEN($G3)<LEN($D$3:$D$26))*0.5)*$C$3:$C$26)

ssg365

表1 =REDUCE(0,D$3:D$26,LAMBDA(x,y,IF(COUNTIF(y,"*"&G3&"*"),x+OFFSET(y,,-1)/(1+ISNUMBER(FIND("/",y))),x)))
表2
=REDUCE(0,$D$3:$D$26,LAMBDA(x,y,IF(AND(TEXT(OFFSET(y,,-3),"m月")=H$2,ISNUMBER(FIND($G3,y))),x+OFFSET(y,,-1)/(1+ISNUMBER(FIND("/",y))),x)))

魚。。

表1：I3公式：（下拉）

1. =SUM(SUMIF(D:D,TEXT(G3,{"!*@!*","@"}),C:C))/2

复制代码

表2：J3公式：（右拉，下拉）

1. =SUM(MMULT(SUMIFS($C:$C,$A:$A,"<"&EDATE(--(J$2&"1日"),{0,1}),$D:$D,TEXT($G3,{"!*@!*";"@"}))*{-1,1},{1;1}))/2

复制代码

hcm19522

H3=SUMPRODUCT((C$3:C$16/(LEN(D$3:D$16)-LEN(SUBSTITUTE(D$3:D$16,"/",))+1))*ISNUMBER(FIND(G3,D$3:D$16)))