Count with interval conditional

[ibmy]

Column A / Column B // Column C

0 / 0.1 // (1)
0 / -0.1 // (2)
0 / 0.1 // (3)
0 / -0.1 // (4)
0 / 0.1 // (5)
-0.1 / 0 // (1)
0.1 / 0 // (2)
0.1 / 0 // (1)
0.7 / 0 //
-0.1 / 0.5 //


Rule:
1) Starting value is 0.1 or -0.1
> Exist at column A or B
2) Other column must 0
3) The count start if next row is -0.1 (starting 0.1) and 0.1 (starting from -0.1).
> The count continues 0.1 -> -0.1 -> 0.1 ........ as long as its not break all above rule..

Break of Rule:
1) Break if other column is not 0
2) Break if it not follow by 0.1 / -0.1

Example of break rule:

1) The count reset (not continue) when not follow 0.1 -> -0.1 -> 0.1 ......

-0.1/ 0 // (1)
0.1 / 0 // (2)
0.1 / 0 // (1)
0.1 / 0 // (1)
0 / -0.1 // (1)
0 / -0.1 // (1)

2) No count when follow by other number than 0.1 / -0.1

-0.1/ 0 // (1)
0.1 / 0 // (2)
0.7 / 0 //

3) No count when other column is not 0.

-0.1 / 0 // (1)
0.1 / 0 // (2)
-0.1 / 0.5 //

p/s:
If 2 column (A&B) is hard to formula at the same time, then formula for 1 column will do. I can do 1 column at one time. I test column A first then column B ( I will apply formula to count at column A first then column B).

Thanks.

 

[Eric W]

I suspect that there's a shorter formula, but I got tied up in knots trying to find one. So I just went back to basics and came up with:

Book1
	A	B	C
1	Column A	Column B	Column C
2	0	0.1	1
3	0	-0.1	2
4	0	0.1	3
5	0	-0.1	4
6	0	0.1	5
7	-0.1	0	1
8	0.1	0	2
9	0.1	0	1
10	0.7	0
11	-0.1	0.5
12	0.1	0	1
13	-0.1	0	2
14	0.1	0	3
15	-0.1	2
16	0.1	0	1
17	0.1	0	1
18	0.1	0	1
19	-0.1	0	2
20	0	0.1	1
21	0	-0.1	2
22	0	-0.1	1
Sheet20

Cell Formulas
Range	Formula
C2:C22	C2	=IF(AND(A2=0,A1=0,B2=0.1,B1=-0.1),N(C1)+1,IF(AND(A2=0,A1=0,B2=-0.1,B1=0.1),N(C1)+1,IF(AND(A2=0.1,A1=-0.1,B2=0,B1=0),N(C1)+1,IF(AND(A2=-0.1,A1=0.1,B2=0,B1=0),N(C1)+1,IF(AND(COUNTIF(A2:B2,0)=1,ABS(A2+B2)=0.1),1,"")))))

 

[ibmy]

Thanks @Eric W , it works great.
Really appreciate your help.