How many times has a number been below zero consecutively formula?

[Jaffabfc]

Hi,

I am trying to get my head around this and i know i am probably looking at it totally wrong.

In column G i have a formula that will determine a loss (so a negative figure) in column O i am wanting to see how many times consecutively it has dropped to a negative.
If it goes into a positive or just to zero i want it to remain blank.

What formula should i use.

thanks

 

[Peter_SSs]

Is this what you mean? If not, some sample data and expected results (with XL2BB) with further explanation please

24 10 18.xlsm
	G								O
1
2	-1								1
3	-5								2
4	-3								3
5	0
6	1
7	0
8	-1								1
9	-4								2
10	0
11	-3								1
12	-1								2
13	-4								3
14	2
15	-3								1
16	-5								2
17	-2								3
18	-1								4
19	-2								5
20	-9								6
21	-4								7
22	1
23	1
24	-3								1
Below 0

Cell Formulas
Range	Formula
O2:O24	O2	=IF(G2<0,N(O1)+1,"")