More Excel help needed

[hans123]

Quote from syswizard:

At this point, explaining this is fruitless...why don't you attach a sample of the actual XLS file for us to review and work-with. That way, there are no misunderstandings.

Ok. Here is an example.

 

[PointOne]

Quote from hans123:

Ok. Here is an example.

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.

 

[hans123]

Quote from PointOne:

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.

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