Calculating value for maximum consecutive value

Originally Posted by rethguals

Hi..
Please check attachment

Thanks a lot for your advice, rethguals. I look through the file but there is still a point. For example, row44, there are two 2 consecutive runs as the maximum run. The sum shall be divided by 4, instead of 2. Any help will be appreciated.