Count the number of times a value is LESS than a threshold for a threshold # days, IF..

edit: sorry, previous title was not correct.

I am trying to modify this array equation...

Formula:

Please Login or Register  to view this content.

Where J5:J12422 is a column of values, $S$4 is a threshold value, and $R$4 is a threshold number of days. It counts the number of periods in which the value is under the threshold value for at least the threshold number of days.

I'd like to find a way to modify the equation so that it ignores days that are OVER the threshold unless there are at least 2 consecutive days that are over the threshold. In other words, if the threshold value is 7 and threshold days is at least 8,

1
5
3
6
8
2
3
2
1

...I'd like it to skip the 8 and count the period as entirely under the threshold. Even though there are nine data points, it would return a "1"...and if

1
5
3
6
8
8
3
2
3

...it would count the two 8's, because there are two consecutive values above the threshold value.

I suggest you attach a sample of your workbook to make it easier to find a solution. See my signature for a link of you are not sure how to attach the file.