I have 10 number (positive or negative) from A1 to J1....

I need a formula in A2 that count starting from A1 how many cell are positive (negative..depending of A1) consecutively

for ex.:

if : A1>0, B1>0, C1>0, D1<0-----> a2= 3

if: A1>0, B1<0, C1>0, D1>0 --------> a2=1 (starting from a1, consecutively by the sign of A1)

se: A1<0, B1<0, C1<0, D1<0, E1<0, F1>0, G1 >0------------> a2= -5

hope to be clear

thanks to all who can