Checking if 20 consecutive numbers in a raw are below a given value

=max(K7:k66)<375

will produce TRUE or FALSE as appropriate

With
A1: the number of consecutive values to check.....60
A2: the threshhold.....................................375

This formula returns TRUE if that number of consecutive values, beginning with cell K7, is less than the A2 value (375)

=MAX((K7:INDEX(K:K,ROW(K7)+A1-1)))<A2

If you change A1 the referenced range will change

Is that something you can work with?

Assuming that you are checking the previous 60 entries and the entries start in K2, enter this in K62 and fill down. TRUE will be returned if all the previous 60 entries are less than 375.

Formula:

=IF(COUNTIF(K3:K62,"<375")=60,"True","")

or simply:

Formula:

=MAX(K2:K61)<375

Here is yet another way. This is easily customizable with the rows value in P1 and the Threshold in P2. If P1 is negative, the rows before are counted (blank if insufficient rows), positive is for rows after.

Formula:

=IF(AND($P$1<0,ROW()-1<$P$1*-1),"",MAX(OFFSET(K2,0,0,$P$1))<$P$2)

If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

You may also say thanks to those who have put their time and efforts to help you in this forum by clicking the Add Reputation link under their posts, another way to say thanks.