Biff,

When I entered your formula it doesn't generate an error message, but it
still only counts the total number of "AA" values.

Since the values I'm using are on another worksheet, and the results on
another, the formula I entered was:
=SUMPRODUCT(--('WIs - All Modules'!A4:A1000="AA"),--(F4:F1000<"NOT REQ'D"))

Would you have any other ideas?
Thanks,
KA

"T. Valko" wrote:
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