It didn't work. the "bbb" is text not numbers. does this matter?


"Gary''s Student" wrote:

Consider using COUNTIF()s and multiplying them.

=COUNTIF(A1:A100,"xxx")*COUNTIF(A1:A100,"bbb")*... ....

if any condition fails, the COUNTIF() will be zero and the product will also
be zero. If 0 then no else yes.
--
Gary''s Student - gsnu200901


"Terri Farm" wrote:

I have been trying for over an hour to get a formula to work. There are 4
specific items included in a column and 1 item in another column that if all
of these meet the criteria, i want a "Y" returned. I am using
If(AND(Bx="xxx")*and(bx="aaa")*and(bx="bbb")*and(b x="ccc")*and(px="r"),"Y","N"))
and I am not getting the "Y" result when the data in bx has the required yes
criteria. what am i doing wrong? I have tried many other ways and nothing
is working