excel用countif函数无法统计出10,15,25,28,29,30+16字符串中的字符个数。
a1单元格内容是 02,09,12,13,18,29+01 01,14,22,25,26,33+03 05,07,22,23,26,31+06 03,13,18,23,28,29+13 01,05,15,18,20,24+02 03,04,06,08,19,32+07 09,12,13,16,22,29+16 11,18,22,24,25,28+06 01,10,13,20,28,30+07 08,19,20,21,23,25+13 03,12,14,18,19,30+12 02,10,14,19,21,25+10 06,08,09,27,29,33+11 03,10,23,27,31,32+08 02,13,14,19,30,33+10 01,02,15,21,25,28+15 04,11,14,16,22,23+06 03,06,09,16,18,19+11 01,03,09,11,27,33+07 09,20,23,25,26,28+01 05,17,21,26,32,33+06 09,13,22,24,29,30+13 02,05,08,11,14,28+07 04,20,23,25,29,32+16 06,09,10,22,24,28+02 05,10,16,23,24,30+13 04,07,11,16,21,32+16 03,08,13,14,26,33+08用countif()函数统计出的数字是0，在该单元格中，用countif函数都是失效的，返回结果仍然是0，加上trim也是一样的，哪位大神知道怎么办？这个函数是不可以统计中一个区域中出现字符的次数吗？类似于countif(a1:a50,"a-11-21")一样不好用啊我想统计的是这列中出现的这个字符串“a-”出现的次数
=LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1," ",),",",),"+",),",",))
看这话“统计出10,15,25,28,29,30+16字符串中的字符个数”，意思是：
求10,15,25,28,29,30+16的字符个数。
俺数一数是20个。在excel中用len函数就得到结果，公式=len("10,15,25,28,29,30+16")