Hi everyone,

I have this spreadsheet with 600rows/6000columns with pozitive and negative values. I have separated negative from pozitive values..so firts I'm asking your help concerning only the pozitve values.
I'm trying to count the series of >= 3 positive cosecutive values (along the column) and than find the sum of these > =3 consecutive values within a series (I need to relate the duration - count consecutive positive values in the series - with the sum - accumulate the values within that series - in order to find the intercept and the slope).
I have this:

values duration accumulated (sum of) values
0
0.742684536
3.482017364
1.998903184 3 6.223605085
0
0
1.158909692
0.75227784
0.457752501 3 2.368940033
0
0.694545405
2.579199295 2
0
9.155731919 1
0
0
5.79161107
0.48423975
0.610211708
2.341454308
0.017378323
0.218719133
2.633191269
5.294876204
1.863866205
0.634789575 10 19.89033755




etc.


Hope I can find help.
Thank you.