Checking values in an array if they pass a certain criteria

[greatsyd]

I would like to check if all values within an array pass a certain criteria without using an extensice number of "AND."

Attached a sample file.

Thank you very much!

[Pete_UK]

You can use this formula in J6:

=COUNTIFS(A6:D6,">=89.5",A6:D6,"<=90.5")=4

and this one in K6:

=COUNTIFS(E6:H6,">=89.5",E6:H6,"<=90.5")=4

although you may need to use semicolons ( ; ) instead of commas ( , ) depending on your regional settings. The formulae will return TRUE if all 4 values are within the range of values, or FALSE if one or more are not.

Copy down as required.

Hope this helps.

Pete

[greatsyd]

Great! THank you!

[Pete_UK]

You're welcome, and thanks for the rep.

Pete