Count consecutive cells that matching a criteria, Starting from the very first cell

[Shameer]

Hello,
In the worksheet uploaded as image,

I need to count
- starting from very First row
- Consecutive occurrences
- if value is greater than 1% and less than 3%

In the uploaded example, the answer would be 1.

Appreciate feedback.

 

[Peter_SSs]

Wondering if ..

1. you tried the alternative formula solution?
2. you could have data like this where the marked solution (cell D1) returns an error rather than a count (cell c1)?

23 10 05.xlsm
	C	D
1	8	#NUM!
2
3
4	2.00%
5	1.55%
6	2.04%
7	2.00%
8	2.00%
9	1.70%
10	1.10%
11	1.80%
Shameer

Cell Formulas
Range	Formula
C1	C1	=IFNA(MATCH(TRUE,ABS(C4:C11-0.02)>=0.01,0)-1,ROWS(C4:C11))
D1	D1	=AGGREGATE(15,6,(ROW($C$4:$C$11)-4)/(($C$4:$C$11<0.01)+($C$4:$C$11>0.03)>0),1)