Forum Discussion
how to count the number of ranges that are seperated by at least one empty cel
i would like to count the number of ranges that are filled with data. In this example the outcome should be that row one has two ranges filed with data. Row 2 as well and row three has three ranges f...
Hi Stefan,
That could be
=SUMPRODUCT((NOT(ISBLANK(B2:K2))*ISBLANK(OFFSET(B2:K2,0,-1))))+NOT(ISBLANK(B2))
Please see attached
