=COUNTIF(ACTIVE!C:C,E22)+COUNTIF(ACTIVE!O:O,B31)
this is the formula that adds them together successfully.

"PCLIVE" wrote:

What is the COUNTIF formula you are using for each?

--

"Kara" wrote in message
...
I am trying to write a formula that uses AND and COUNTIF. I want it to
count
how many have 1-critical AND incorrect value. I have the COUNTIF working,
but
don't know how to connect them properly. Thanks for the help!