I am trying to count max number of consecutive positive in Google Sheets and I can't find a solution, I saw this formula on the web but it doesn't work, does anyone have any idea how to do it?


enter image description here


1 Answer 1


To find the length of the longest streak of positive integers in row 4, use this:

=arrayformula( max( len( split( join( "", left(B4:Y4 > 0) ), "F" ) ) ) )

Copy the formula down to extend it to additional rows.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.