在excel中，我想计算不包含特定字符的单元格的数量 [英] in excel, I want to count the number of cells that do not contain a specific character

问题描述

在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中，我想计算不包含特定字符的单元格的数量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！