MAX Consecutive across columns

[williampdx]

Hello everyone.
I would really appreciate some help on this one - here is what I need to figure out (see attached .xlsx file)

In E209, I need an array that will count MAX consecutive wins ongoing throughout time. And in E210, to count MAX consecutive losses (less than$0). The issue I have is that the wins (a win being any value greater than 0), are located on each daily row and in columns I,Q,Y,AG,AO,AW, and BE. After column BE ,it should again look to the next row and continue the MAX count at column I all the way down. Since there is a blank row every 5th row, it will need to skip that row, or not count blank values. Also, if the columns I need it to look at have a value of $0, i need it to disregard counting it but without resetting the MAX count.

I know I could have physically counted this myself in the time I could have solved this problem but I would rather figure out the correct way to write this array.

Any help would be much appreciated!!!

William