Countifs same column different criteria

Karrie Davis
Karrie Davis Overachievers Alumni
edited 12/09/19 in Formulas and Functions

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




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!