Count consecutive values above or below 50 depending on the last value in the column

Hello,

I have for example the following set of data:

51
52
53
49
52
51
48
47

I am hoping someone knows a formula that can count the consecutive values above or below 50 depending on the last value in the column.
In this case becuase the last value (ie 47) is below 50, the formula should return 2 (counts 47 and 48).

If the data set was:

51
52
53
49
52
51
52
53

The formula should return 4 (counts 53, 52, 51 and 52).

I have been scouring the internet for a solution with no avail. Hoping someone has a solution for this.
Appreciate your help.

The dividing line is 50. So for the values you indicated it should return 4

General,

I think i see what you are doing - let me rephrase what i am looking to achieve.

I have a series of data that comes in monthly.
If the last value is below 50, I want a function that will count how many consecutive months the reading was below 50.
At the same time the function needs to count how many consecutive months the reading was above 50, if the last value was above 50.

So if I have the following data on month 5

month 1: 51
month 2: 49
month 3: 51
month 4: 52
month 5: 53
With the fifth month being the most recent and therefore the starting point.

The function should return a 3.

Now in month 6:

month 1: 51
month 2: 49
month 3: 51
month 4: 52
month 5: 53
month 6: 49

The function needs to return a 1.

Does that help?

Kaper, unfortunately my firewall is blocking me from opening your attachment.
I will have to check later on a different computer if that solution works.

Appreciate you taking the time and will let you know.

Thanks for your help General - I'm going to try and go with Kaper's approach.
I may need some help implementing the VBA language.

ChemistB thank you so much - much appreciated!