Ahh - so they are literally sequential integers 1,2,3... Most people would assume you wanted a general solution for any integer (no particular sequence). This is trivial. In next column (B): =if(A1<>0,1,0) Copy this formula down - so you only have 1s and 0s in the resulting column. Then sum only the 1s from the bottom of the list - et voila, the total number of winning trades in each streak is at the top: e.g. in column C =if(B42=0,0,b42+c43) Copy formula upwards. The winning streaks are reset to start from 0 each time given your format. You also need to work on your communication skills as I 'm still not 100% sure this is what you want.
Sorry, but this is not working. The total number of winning trades should be at the bottom, not at the top. But it helped me to find the solution. It should be: =IF(B2=0,0,B2+C1) Thanks for helping. Hans