multiple cut offs, possible array solution?

[JoshuaSQ]

I am wondering if there is an easier way to accomplish the following task:

If i have 5 variables in the range (B9:F25), I want to indicate if any of the variables fall below a cut off that is indicated in B$2:F$2.

I would prefer to do this with out adding helper columns, the best solution i have found is a sumproduct. like:

K2 =sumproduct((B9<B$1)+(C9<C$1)+(D9<D$1)+....)

this formula would then be copied down...

Please see the attached file. I am looking for the easiest solution, one that takes a minimal amount of processing resources would also be good.

And ideas?

Thanks

[shg]

Change G8:K8 to be just 1, 2, 3, 4, 5 instead of Set 1, Set 2, ...

In G9 and copy right and down,

=SUMPRODUCT(--($B9:$F9 < INDEX($B$2:$F$6, G$8, 0) ) )

[JoshuaSQ]

Thanks! that works great!