find largest pair of consecutive numbers?

[Guitarmageddon]

So I have some sales data and it is a item number in $A$1 for example, and b$1 (or whatever column it stops) and so on in the rows out to the right are weekly sales numbers. I am trying to use a formula to select the range of sales numbers and just give me the greatest consecutive two weeks of sales that occurred, and what that sum would be. Can someone help out?

 

[Legacy 143009]

Impossible without VBA. You have to make several logic checks.

 

[Guitarmageddon]

Actually there was a simple solution to this, no need to complicate! Excel just learns that I'm doing a SUM for 2 consecutive cells and repeats the pattern, then I just turn around and do a MAX. This was easy haha. Thanks

 

[steve the fish]

This with CTRL-SHIFT-ENTER

=MAX(A1:Z1+OFFSET(A1:Z1,,1))