I am using this formula

*which is an array to identify every 5 consecutive numbers above 5.*

**=SUMPRODUCT(--(FREQUENCY(IF(D3:D38>=5,ROW(D3:D38)),IF(D3:D38<=4,ROW(D3:D38)))=5))**The only problem is if there are more then 5 consecutive numbers and not exact 5 then it wont return anything which is not helpful the formula works for exact 5 consecutive numbers.

**-2**

-1

-1

**so, using this formula it will return zero as I have more then 5 consecutive numbers above 5, when it should return 1,and in the case of having 10 consecutive numbers higher then 5 it should display 2. For every five consecutive numbers above 5.**

4

3

2

1

*3*

8

7

6

5

8

98

7

6

5

8

9

4

3

2

1

Thank you for your support.