分别三次(段)按条件提取“F7”里面数的个数谢谢！

909459520 · 发表于 2023-6-24 08:35

无聊的黑猫 · 发表于 2023-6-24 08:59

=SUMPRODUCT(ISNUMBER(FIND(","&ROW(INDIRECT(G$5&":"&G$6))&",",","&SUBSTITUTE(SUBSTITUTE($F7,"(",","),")",",")&","))*1)

909459520 · 发表于 2023-6-24 09:15

无聊的黑猫发表于 2023-6-24 08:59
=SUMPRODUCT(ISNUMBER(FIND(","&ROW(INDIRECT(G$5&":"&G$6))&",",","&SUBSTITUTE(SUBSTITUTE($F7,"(","," ...

非常敬佩您助人为乐的精神！致敬！

tchh666 · 发表于 2023-6-24 09:15

=COUNT(VDB(,,G$6,G$5,ROW($1:$99)/ISNUMBER(FIND(","&ROW($1:$99)&",",","&SUBSTITUTE(SUBSTITUTE($F7,"(",),")",)&","))))

复制代码

909459520 · 发表于 2023-6-24 10:24

无聊的黑猫发表于 2023-6-24 08:59
=SUMPRODUCT(ISNUMBER(FIND(","&ROW(INDIRECT(G$5&":"&G$6))&",",","&SUBSTITUTE(SUBSTITUTE($F7,"(","," ...

老师能否设计为“F7”里面无数据(橙色)函数结果为“空值”或者结果为“零”时也为“空值”。谢谢！

909459520 · 发表于 2023-6-24 10:25

tchh666 发表于 2023-6-24 09:15

老师能否设计为“F7”里面无数据(橙色)函数结果为“空值”或者结果为“零”时也为“空值”。谢谢！

tchh666 · 发表于 2023-6-24 10:29

909459520 发表于 2023-6-24 10:25
老师能否设计为“F7”里面无数据(橙色)函数结果为“空值”或者结果为“零”时也为“空值”。谢谢！

=TEXT(SUMPRODUCT(ISNUMBER(FIND(","&ROW(INDIRECT(H$5&":"&H$6))&",",","&SUBSTITUTE(SUBSTITUTE($F7,"(",","),")",",")&","))*1),"0;;")

复制代码

无聊的黑猫 · 发表于 2023-6-24 10:41

909459520 发表于 2023-6-24 10:24
老师能否设计为“F7”里面无数据(橙色)函数结果为“空值”或者结果为“零”时也为“空值”。谢谢！

=TEXT(SUMPRODUCT(ISNUMBER(FIND(","&ROW(INDIRECT(H$5&":"&H$6))&",",","&SUBSTITUTE(SUBSTITUTE($F7,"(",","),")",",")&","))*1),"[>0];")

		自动登录	找回密码
密码			免费注册

[求助] 分别三次(段)按条件提取“F7”里面数的个数谢谢！