Here is a sequence of numbers in a column

100

20

-78

5

-99

-54

-34

6

0

34

55

89

32

-3

-78

Now I need to COUNT the number of instances of the following data set. The answer is in brackets:

1 positive number on its own (2)

2 positive values in a row (1)

3 positive values in a row (0)

4 positive values in a row (1)

1 0 value on its own (1)

2 0 values in a row (0)

3 0 values in a row (0)

4 0 values in a row (0)

1 negative number on its own (1)

2 negative values in a row (1)

3 negative values in a row (1)

4 negative values in a row (0)

Any ideas on excel formula very welcome!