Counting Instances where 3 or more concurrent cells containing specific text

In DA4:

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

Hey David,

What should happen in 4 "Data" are in a row? Should that give 2?

BTW - I like Bebo's answer.

Originally Posted by MarvinP

Hey David,
What should happen in 4 "Data" are in a row? Should that give 2?
BTW - I like Bebo's answer.

Thaks for kind words, Marvin.
Title said "3 or more..." is clear.

Originally Posted by bebo021999

=SUMPRODUCT(--(FREQUENCY(IF($B$4:$CZ$4<>"",COLUMN($B$4:$CZ$4)-MIN($B$4:$CZ$4)+1,""),IF($B$4:$CZ$4="",COLUMN($B$4:$CZ$4)-MIN($B$4:$CZ$4)+1,""))>=3))

Try it like this...

Array entered**:

=SUM(IF(FREQUENCY(IF(B4:CZ4<>"",COLUMN(B4:CZ4)),IF(B4:CZ4="",COLUMN(B4:CZ4)))>=3,1))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.