Counting Streaks

[Umbaste]

Hello. I apologize in advance, since English isn't my first language, and there's a chance this question might have already been solved without me knowing the exact terms.

On to the problem. I'm doing analysis of variance on a set of data, and I'm stuck on a bit where I have a row of ten closely grouped values, either positive or negative (residuals, to be exact). What I need now is a formula so Excel can automatically count the number of streaks (as in, how many groups of uninterrupted sequences there are in the block of data). How could I do this?

 

[bebo021999]

Provide an image/screenshot or XL2BB may helps.

 

[Umbaste]

Sorry. Can't download xl2bb for some reason, let's see if I can't explain myself like this. Say the data line goes something like this:

1

-2

-1

-1

2

2

-1

2

2

2

The first streak would be the first one; the second would start from the first negative two and through the two negative ones, the third would be the two twos, the fourth would be the negative one, and the fifth would be the final three twos. I need a formula for Excel to look at this row and give me the number of streaks.

 

[bebo021999]

So, moving from the left, if value change the sign( neg to pos or vice versa) then counts 1? Is that right?