Count consecutive data under thresholds

Greetings.

I'm working with a sheet for weather windows regarding offshore installation of windfarms.
It' consist of large amount of data for 30 years windclimate; Windspeed, Waveheight and temperature.

My current solution is too heavy for computing at this point, so I need help with a new approach to this problem.
I need to count the consecutive hours, in which the values of wind/waves/temp do not exceed the thresholds.

ATM, im using the approach =AND(U2<=$B$2;U3<=$B$2), creating 2 hours of values i U, being less than the threshold B2. The I just count the TRUE statements later for probability of it happening.
For a 4 hour window i use =AND(U2<=$B$2;U3<=$B$2;U4<=$B$2;U5<=$B$2) and so on and so on.
This results in way too much data, and I'm sure the must be an easier solution.

The model should be able to enter a value for; Hours, max windspeed, max waveheight and max. temperature.

I need a function that uses the hours (4), to search fx. for 4 consecutive hours of values under the threshold.

help.PNG

I hope you are able to help me.

Thank you.

I'm able to count.if, but unable to incorporate the criteria of fx. 4 consecutive hours.

can you please attach your workbook if you don't mind to understand better.
Regards

Thanks for the welcome and swift respons.

I have attached a file, showing the idea I have used so far, and how I imagine the layout for a solution.

B2:B5 are the thresholds, and input for the model.
J, K and L are simple AND-functions stating if the thresholds are good or not.

Working hours, are the number of hours in which all the statements are true.

The problem is, I dont know how to make a function that uses the parameter "hours".
If Hours is 6, it need to look in coloumn J, K and L for 6 consecutive hours where the values matches the threshold.

Hope that clafiries my intended purpose.

Thank you

Hello
Here come into action the array formulas
I have made the changes
This formula will count the specified no. of hours for which all the three values were below or equal to the threshhold.
Hope this is what you need.
Do ask for any other changes you want.



If you were satisfied with my answer then please click on Add Reputation below......
Regards
Sourabh Gupta

Yes, this is excactly what I needed.

Thanks for the answer, you sir deserves the reputation!

I'm not quite sure i fully understand this.
In M,N and O, when it displays the interval to look for, G2:G4, G3:G5 for 2 hours etc.
It seems it resets when it gets to 10. Fx. G9:G2
Is it true? Or am I doing it wrong when Im extending the formular when im trying to add more data to G,H and I.

Thank you

Hi
I am Glad to know it worked
And sorry for my that silly mistake......
Now use this one----

Regards
Sourabh Gupta

Hi
The update works perfectly, well done!

Thank you