How to count sets of text

Hello,

I'm having problem with count function. I would like to count how many "sets" of text before blank coulmn is there in one row.

In example: In row 1 there is text "SD" in columns A, B, C and then D is blank and then in E, F, G there is text "LD". So count or some other function should return number 2 because there are two sets of text - A,B,C and D,F,G

Does anyone have some idea?


Thank you and have a great day.

Perhaps you could try something like this in say G2: =SUMPRODUCT(--(B2:F2<>""))
Copy down