Sum consecutive row values and rank the biggest consecutive values

[Mantiyeah]

I have a column with different values from 0 to 100. I would like to group those values into consecutive groups of 20 values , sum those values and rank them depending on which sums are the greater and point me to where those values are.
Ideally the ranks would be divided into the highest sum of 20 consecutive numbers.

Any formulas which I can look into? to work in it

 

[Mantiyeah]

Just to clarify it, the values that I have are not in order and can go from 0 to 100. I have a huge amount of values so I would need something to point me to where those hot areas are