J2{=INDEX(D:D,SMALL(IF(MATCH(1+(ISERR(FIND("前场",C$2:C$6)))&D$2:D$6,1+(ISERR(FIND("前场",C$2:C$6)))&D$2:D$6,)=ROW($1:$5),ROW($2:$6),99),ROW(A1)))&""
K2{=IFERROR(LOOKUP(1,0/FIND({"前场","后场"},INDEX(C:C,SMALL(IF(MATCH(1+(ISERR(FIND("前场",C$2:C$6)))&D$2:D$6,1+(ISERR(FIND("前场",C$2:C$6)))&D$2:D$6,)=ROW($1:$5),ROW($2:$6)),ROW(A1)))),{"前场","后场"}),"")
L2=IF(J2="","",SUMPRODUCT(G$2:G$6*(D$2:D$6=J2)*ISNUMBER(FIND(K2,C$2:C$6))))
M2=IF(J2="","",SUMPRODUCT((D$2:D$6=J2)*ISNUMBER(FIND(K2,C$2:C$6))))
留言
張貼留言