Countifs same column different criteria

Karrie Davis

Hi I'm trying to count the items in the in one column if they are not equal to criteria in another column. May someone assist. This is what I have so far.

=COUNTIFS({FDA Submission 2019 Range 1}, "DE Novo", {FDA Submission 2019 Range 2}, OR(@cell <> "Approved", @cell <> "Rejected", @cell <> "Withdrawn"))

However everything is still be counted. I just want it to count if it is a De Novo and not equal to Approved, Rejected or Withdrawn

 

Thanks

Nic Larsen

Try adding the NOT function and changing the <> to =, like this:

NOT(OR(@cell = "Approved", @cell = "Rejected", @cell = "Withdrawn")))

Karrie Davis

Thank you, that worked

Paul Newcome

You could also use your original formula but swap out the OR with an AND

 

=COUNTIFS({FDA Submission 2019 Range 1}, "DE Novo", {FDA Submission 2019 Range 2}, AND(@cell <> "Approved", @cell <> "Rejected", @cell <> "Withdrawn"))

 

This will also work for you.