本文介绍了在excel中，我想计算不包含特定字符的单元格的数量的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
在excel中，我想计算不包含特定字符(在这种情况下为."/句点)的单元格的数量.
in excel, I want to count the number of cells that do not contain a specific character (in this case, a "." /period).
我尝试了类似countif(A1:A10，<>.*")的操作，但这是错误的，我似乎无法弄清楚.
I tried something like countif(A1:A10,"<>.*") but this is wrong and I can't seem to figure it out.
说我在A列中有这些数据:
Say I have these data in column A:
D
N
P
.
.
A
N
.
P
.
计数为6
推荐答案
例如:
=COUNTIF(A1:A10,"<>.")
返回 6 .但是，如果说您也想从计数中排除 P.，那将是另一回事.
returns 6. But it would be a different story if say you wanted to exclude P. from the count also.
您的数据可能与您想像的不一样，因为包含 * 对您的示例没有影响.
Your data may not be quite what you think it is however, because including the * should make no difference for your example.
这篇关于在excel中，我想计算不包含特定字符的单元格的数量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！