Hello all, I have a question regarding the count functions with excel. I am wondering how to count sets of "unique" empty cells within a range? Take the example below:

\1

Within a row, I would like a count of how many instances of "2 empty cells in a row", and how many instances of "3 empty cells in a row", and how many instances of "4 empty cells in a row", etc, etc.

So in the first row, there are 2 instances of "2 empty cells in a row", 1 instance of "3 empty cells in a row", and 1 instance of "5 empty cells in a row".

The second row has 3 instances of "2 empty cells in a row", and 2 instances of "3 empty cells in a row".

How would I go about counting all the sets of empty cells and defining them in a table?