计算空白单元格，直到达到非空白单元格 [英] Count blank cells till a non blank cell is reached

问题描述

大家好，



希望你做的很棒.. !!



我有这个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?

推荐答案

尝试使用此公式（对我来说，这个公式在单元格I2中）

= COLUMNS（A2：H2）-COUNT（A2：H2）-LOOKUP（2,1 /（A2：H2"），COLUMN （A2：H2））

Try using this formula(For me this formula was in cell I2)
=COLUMNS(A2:H2)-COUNT(A2:H2)-LOOKUP(2,1/(A2:H2<>""),COLUMN(A2:H2))

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

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