Hello there.
I have many spreadsheets with precipitation of rainfall. Each one has the height of the rainfall (in millimeters) in a given day of a given month. This is an example of just three months (generally we have 900+ months):
I want to get a formula (if possible) that gets the highest sum possible of 2, 3, 5, 7, 10, 15 and 20 >consecutive< values of rain.
This does not mean reading the highest rain, reading the second highest rain, and then adding them to get Max2days.
What I want is a way of checking every two consecutive days, adding them and giving back the highest sum possible for this month (the same for 2, 3, 5, 7, 10, 15 and 20 days)
Thanks in advance!
I have many spreadsheets with precipitation of rainfall. Each one has the height of the rainfall (in millimeters) in a given day of a given month. This is an example of just three months (generally we have 900+ months):
I want to get a formula (if possible) that gets the highest sum possible of 2, 3, 5, 7, 10, 15 and 20 >consecutive< values of rain.
This does not mean reading the highest rain, reading the second highest rain, and then adding them to get Max2days.
What I want is a way of checking every two consecutive days, adding them and giving back the highest sum possible for this month (the same for 2, 3, 5, 7, 10, 15 and 20 days)
Thanks in advance!