Count sequence of positive numbers

[PhilipeC]

I want to count the sequence of positive number from i4:i20, if i4:i20 there more than one positive number than it will count the sequence, but only if there more than one positive number from i4:i20?

 

[RasGhul]

Try

=IF(COUNTIF($I$4:$I$20,">="&0.01)>1,COUNTIF($I$4:$I$20,">="&0.01),"")

 

[Aladin Akyurek]

Care to post what you have in I4:I20 along with expected output?