Finding the sum of the two highest consecutive values in a range

[msoff]

Hello,


I have a list of weeks with values associated to them as found in the excel doc 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?

[catchnanan]

Please Login or Register  to view this content.

[Glenn Kennedy]

With the number of values to be included in A5


=AGGREGATE(14,6,SUBTOTAL(9,OFFSET($A$2:$AZ$2,,ROW(INDIRECT("1:"&COLUMNS($A$2:$AZ$2)-A5+1))-1,,A5)),1)