consecutive positive or negative

[kong]

hi to everybody

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

 

[Richard Schollar]

Ha ha, yes you are. It must be one of those days.

Hmm, maybe it's lack of beer - given it's lunchtime, I think I'll go take care of this particular problem...

 

[GlennUK]

What a good idea ... pity I haven't got time to do the same today.