求助平分次数的公式

270912979

求助平分次数的公式，望大神们指点。谢谢

无关岁月

1. =SUM(ISNUMBER((1-VDB(,,G$2,G$1,C$4:C$11))/FIND(F4,B$4:B$11))/(LEN(B$4:B$11)-LEN(SUBSTITUTE(B$4:B$11,"+",))+1))

复制代码

1. =SUM(ISNUMBER(FIND(F$8,B$4:B$11))*(D$4:D$11=G9)/(LEN(B$4:B$11)-LEN(SUBSTITUTE(B$4:B$11,"+",))+1))

复制代码

quqiyuan

1. =SUM(IFERROR(1/((ISNUMBER(FIND(F4,$B$4:$B$11))*(LEN($B$4:$B$11)-LEN(SUBSTITUTE($B$4:$B$11,"+",))+1))*($C$4:$C$11>=$G$1)*($C$4:$C$11<=$G$2)),0))

复制代码

1. =SUM(ISNUMBER(FIND($F$8,$B$4:$B$11))*(G9=$D$4:$D$11)/(LEN($B$4:$B$11)-LEN(SUBSTITUTE($B$4:$B$11,"+",))+1)*($C$4:$C$11>=$G$1)*($C$4:$C$11<=$G$2))

复制代码

270912979

quqiyuan 发表于 2024-8-13 21:02

谢谢大神，我去试试

270912979

无关岁月 发表于 2024-8-13 20:05

谢谢大神。。我试试

270912979

quqiyuan 发表于 2024-8-13 21:02

大神，能再帮忙下吗，前面写错格式了。谢谢

270912979

无关岁月 发表于 2024-8-13 20:05

大神，前面写错格式了，第二个公式条件我改下，能再帮忙看看吗？谢谢

quqiyuan

270912979 发表于 2024-8-13 22:18
大神，能再帮忙下吗，前面写错格式了。谢谢

=SUM(ISNUMBER(FIND($F$8,$B$4:$B$11))*(G9>=LEFT($D$4:$D$11,2))*(G9<=RIGHT($D$4:$D$11,2))/(LEN($B$4:$B$11)-LEN(SUBSTITUTE($B$4:$B$11,"+",))+1)*($C$4:$C$11>=$G$1)*($C$4:$C$11<=$G$2))

270912979

quqiyuan 发表于 2024-8-13 22:27
=SUM(ISNUMBER(FIND($F$8,$B$4:$B$11))*(G9>=LEFT($D$4:$D$11,2))*(G9=$G$1)*($C$4:$C$11

怎么没出来数据呢。。还是0

quqiyuan

270912979 发表于 2024-8-13 22:48
怎么没出来数据呢。。还是0

left right 函数前加 1* 试一下，让文本值变成数值