Count occurances when value appears >=3 times

[Karen311261]

Hi All

I need a formula that will count the number of times the number 4 appears in my row of data >=3 time

Your help is appreciated

Karen

[dilipandey]

Hi Karen,

I believe you can use Countif formula here but not sure about

data >=3 time

Upload a sample workbook to clarify .. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[vlady]

=if(COUNTIF(A1:A5,"=4")>=3,COUNTIF(A1:A5,"=4"),"less than 3")

[Karen311261]

The number needs to be consecutive

for example

1,2,3,4,4,4,4,1,2,4,4,4 =2


2,3,4,4,4,1,2,3,1,2,3,2 =1

[vlady]

count 4 if consecutive...

count consecutive.xlsx