K
KA
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
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