Good morning I would need a formula to check if there are 5 consecutive numbers >1 and add them.
In case there were 2 sequences of 5 numbers > 1 add the one with the highest value.
In the case of column E the consecutive numbers >1 are 7 and we must see which combination gives the largest value as in the example F16: H20
The result entered by hand is in G2: J2
Thank you
Bookmarks