Try this:

=SUMPRODUCT(--(A4:A1000="AA"),--(B4:B1000<"NOT REQ'D"))

--
Biff
Microsoft Excel MVP


"KA" wrote in message
...
Hello,
I want a row counted only if the row contains the letters "AA" in one cell
and does not contain the letters "NOT REQ'D" in another cell of the same
row.

The COUNTIF statement works fine. =COUNTIF(A4:A1000,"AA")

However, I tried adding the AND statement but can't get it to work.

Would someone be able to help please?
Merci,
KA