0

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?

=MAX(FREQUENCY(IF(A1:M1>0,COLUMN(A1:M1)),IF(A1:M1<0,COLUMN(A1:M1))))

enter image description here

1
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, privacy policy and cookie policy