Hello,
I have a list of weeks with values associated to them as found in the excel picture attached.
I'm trying to find a formula to find the sum of the two highest values from 2 consecutive weeks.
Same thing with 10 consecutive weeks.
Ex:
Row1: Week 1, Week 2, Week 3
Row2: 5, 10, 15
In this example the answer would be 25.
Can you please help me?
I have a list of weeks with values associated to them as found in the excel picture attached.
I'm trying to find a formula to find the sum of the two highest values from 2 consecutive weeks.
Same thing with 10 consecutive weeks.
Ex:
Row1: Week 1, Week 2, Week 3
Row2: 5, 10, 15
In this example the answer would be 25.
Can you please help me?