问题描述
大家好，
希望你做的很棒.. !!
我有这个excel表，我需要计算范围内的空白单元格，直到达到非空白单元格。
A | B | C | D | E | F | G | H |算上
x | x | - | - | - | x | - | - | 2
x | x | - | - | - | - | - | x | 0
由于最后一列是空白的第一行，因此考虑下一个值。输出为2，因为在任何非空白单元格之前有两个空格。
在第二行中，由于最后一列有值，所以它会立即打印0。 br />
我尝试过：
= IF（cell = ，something_to_count_blanks，0）
如何计算这些空白单元格？
Hello everyone,
Hope you are doing great..!!
I have this excel sheet and I need to count blank cells from a range till a non blank cell is reached.
A | B | C | D | E | F | G | H | Count
x | x | - | - | - | x | - | - | 2
x | x | - | - | - | - | - | x | 0
In first row since the last column is blank, so next values are considered. Output is 2 cause there are two blanks before any non-blank cell.
In second row, since last column has value, so it will straight away print 0.
What I have tried:
=IF(cell="",something_to_count_blanks,0)
how to count those blank cells?
推荐答案
A B C D E F G H Result
x 7
x 6
x 5
x 4
x 3
x 2
x 1
x 0
这篇关于计算空白单元格，直到达到非空白单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！