Hi all, I am completely newb in excel and was looking for help on something.
I am using this formula =IF(H2<0;Z1+1;0) in cell Z1 for calculating cumulative losses before having a winner. H2 is the range from which we calculate.
An example of the result of this formula would be:
0
1
2
0
0
1
2
3
4
0
I need a formula that calculates the amount of losses in a row before getting a winner, which is marked by 0, so for example:
0
1
2 2
0
0
1
2
3
4 4
0
Hope it's understandable. Deeply appreciate the help, thanks
Bookmarks