counting blank spaces within a column

Question

I would appreciate some help with the below problem if possible.

i am trying to find a formula, that can count blank spaces in between rows within a single column

if you look at the attached file. Within the comment section i explain what i am trying to do.

any help is most welcomed.

regards

terry

jorge_peony · Answer

Use the COUNTBLANK function to count the number of empty cells in a range of cells.https://support.microsoft.com/en-us/office/countblank-function-6a92d772-675c-4bee-b346-24af6bd3ac22

hansvogelaar · Answer

Terence019740&nbsp;
In B2:
=IF(A2="", "", COUNTBLANK(A$1:A1)-SUM(B$1:B1))
Fill down.

terence019740 · Answer

HansVogelaar&nbsp;thank you very much for your help it has been a great help.&nbsp;kind regards&nbsp;Terence.

Forum Discussion

counting blank spaces within a column

3 Replies

Resources