=COUNTIF(A2:G2,"N")0

Believe Bob meant:
=COUNTIF(E2:G2,"N")0

(Aha, gotcha Bob ! <g)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Bob Phillips" wrote in message
...
I would just use

=COUNTIF(A2:G2,"N")0

and filter on TRUE <g

--
HTH

Bob