On Apr 11, 10:40 am, Ron Coderre
wrote:
Ooops! I only pasted part of the formula. Here's the whole thing:

=IF(SUMPRODUCT(--(ROW(W4:W27)={4,8,13,16,22,27})*(W4:W27="PASS"))=6 ,"PASS",*"FAIL")

Does that help?


<snip


Yes, Ron, Thank you; I knew it could be done more efficiently
somehow.

Thanks to everyone else too, but this one fits my needs for this
particular problem (everything being in one row/column). :)

Nikki