Sum values from maximum consecutive string

[kingjas]

I have a few thousand rows of data. Each row contains a weekly quantity for the last 52 weeks. I have already determined how to find the maximum number of consecutive weeks greater than 0, but need to sum the values associated with the largest consecutive string. I've attached a small subset of the data. In this example, I have the following data:
A1 B1 C1 D1 E1 F1 G1 H1 I1
1000 0 0 700 500 500 0 0 200

I know the max frequency = 3, but I need to sum those 3 data points (700+500+500).

Thanks in advance!

[Tony Valko]

Try this array formula**:

=SUM(OFFSET(INDEX(A2:I2,MATCH(J2,COUNTIF(OFFSET(A2,,COLUMN(A2:I2)-COLUMN(A2),,J2),">0"),0)),,,,J2))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

[kingjas]

Tony - works great! Thanks...much appreciated!!

[Tony Valko]

You're welcome. Thanks for the feedback!

[daddylonglegs]

If there was more than one instance of the maximum number of consecutive week > 0 what result would you want then?