I have rows of data containing zeros and ones. I need a formula that counts the number of zeros in a particular row, that are contained within at least 18 consecutive zeros. Some rows contain 2 ranges of at least 18 consecutive zeros so I would want to total that.
There are 48 columns per row. Please see example attached - column AW should show the answer.
Thanks in advance.
Also posted here: https://www.mrexcel.com/forum/…ve-zeros.html#post4733795