how to count streak in range ascending

[nadavrock]

i have a column with numbers 0-10. i want to display in a desginated cell. the current streak. as in currently how many cells in a row are greater than 0. from the top. how do i do this?

 

[nadavrock]

how do i make it work for streak of greater than 1? i treid changing the > 0 to > 1 but it didnt work

 

[Rick Rothstein]

how do i make it work for streak of greater than 1? i treid changing the > 0 to > 1 but it didnt work

It works for me. Explain exactly what you did that led you to believe it did not work.

 

[nadavrock]

never mind it was a range error i fixed it. thanks anyway for the quick reply