计算特定范围/列Excel中的非空白行 [英] Count non blank rows in a certain range/column Excel

问题描述

我想计算给定列(或范围)中的空(或非空)行. 示例:我有一列跨越4个单元格宽度的列，每个单元格都带有一个"x"或为空.此列下最多有100行.这是需要澄清的图片:

I want to count empty (or non-blank) rows in a given column (or range). Example: I have a column which is spaning over 4 cells width, and each cell has either a single ''x'' or is empty. There is up to 100 rows under this column. Here's a picture to clarify:

推荐答案

COUNTA()函数将为您完成此任务.例如:

The COUNTA() function will do that for you. For example:

=COUNTA(A1:A100)

将返回在 A1:A100

这篇关于计算特定范围/列Excel中的非空白行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！