计数与求和~~~~

狗剩呵呵哒

计数与求和，求帮助~~~~

小凡、、、

良良

F8=SUM(LEN(IF($A$5:$A$9=$E8,$C$5:$C$9,""))-LEN(SUBSTITUTE(IF($A$5:$A$9=$E8,$C$5:$C$9,""),F$7,)))，下拉、右拉。

F12=F8*B$2，下拉、右拉。

我的城市你来过

=IFNA(SUM(LEN(REGEXP(CONCAT(FILTER($C$5:$C$9,$A$5:$A$9=$E8)),F$7))),0)
=F8:J9*B2:F2

狗剩呵呵哒

我的城市你来过 发表于 2024-5-27 19:14
=IFNA(SUM(LEN(REGEXP(CONCAT(FILTER($C$5:$C$9,$A$5:$A$9=$E8)),F$7))),0)
=F8:J9*B2:F2

谢谢，不过REGEXP这个函数我用不了

剑指E

F8:

1. =DROP(REDUCE(0,E8:E9,LAMBDA(u,v,VSTACK(u,LET(x,FILTER(C5:C9,A5:A9=v),BYCOL(LEN(x)-LEN(SUBSTITUTE(x,F7:J7,)),LAMBDA(y,SUM(y))))))),1)

复制代码

F12:

1. =XLOOKUP(F11:J11,1:1,2:2)*F8#

复制代码

逐渐陌生

=REDUCE(E7:J7,UNIQUE(A5:A9),LAMBDA(x,y,VSTACK(x,HSTACK(y,LET(c,CONCAT(FILTER(C5:C9,A5:A9=y)),d,MID(c,SEQUENCE(LEN(c)),1),MAP(B1:F1,LAMBDA(z,COUNTA(FILTER(d,d=z)))))))))


=REDUCE(E11:J11,UNIQUE(A5:A9),LAMBDA(x,y,VSTACK(x,LET(c,CONCAT(FILTER(C5:C9,A5:A9=y)),d,MID(c,SEQUENCE(LEN(c)),1),h,HSTACK(d,XLOOKUP(d,B1:F1,B2:F2)),HSTACK(y,TOROW(MAP(B1:F1,LAMBDA(z,IFERROR(SUM(FILTER(TAKE(h,,-1),TAKE(h,,1)=z)),0)))))))))

mykitami

=SUM(N(MID(CONCAT(FILTER($C$5:$C$9,$A$5:$A$9=$E8)),SEQUENCE(99),1)=F$7))
=F8:J9*B2:F2

一杯绿茶来了

=SUM(($A$5:$A$9=$E8)*(MID($C$5:$C$9,COLUMN($A:$F),1)=F$7))
=SUM((MID(CONCAT(IF($A$5:$A$9=$E12,$C$5:$C$9,"")),ROW($1:$22),1)=F$11)*HLOOKUP(F$11,$1:$2,2,))

laomu2010

G8=SUM((((MID($C$5:$C$9,SEQUENCE(,5),1)=G$7))*1)*($A$5:$A$9=$F8))
G12=LOOKUP(G$11,$B$1:$F$1,$B$2:$F$2)*SUM((((MID($C$5:$C$9,SEQUENCE(,5),1)=G$7))*1)*($A$5:$A$9=$F8))