计算包含任何文本的单元格 [英] Count cells that contain any text

问题描述

我想计算包含某个范围内任何内容的单元格. 任何包含文本，数字或其他内容的单元格都应在我的结果单元格中加一.

I want to count the cells that contain anything within a range. Any cell that contain text, or numbers or something else should do a plus one in my result-cell.

我发现了这个功能，

countif(range; criteria)

但这对我不起作用，因为我不知道在标准中键入什么.我该怎么办?

but this doesn't work for me, because I don't know what to type in the criteria. How can I do this?

推荐答案

您可以传递"<>"(包括引号)作为criteria的参数.这基本上就是说，只要它不为空/空白，就算它.我相信这就是您想要的.

You can pass "<>" (including the quotes) as the parameter for criteria. This basically says, as long as its not empty/blank, count it. I believe this is what you want.

=COUNTIF(A1:A10, "<>") 

否则，您可以按照Scott的建议使用CountA

Otherwise you can use CountA as Scott suggests

这篇关于计算包含任何文本的单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！