Countifs same column different criteria
Options
Karrie Davis
Overachievers Alumni
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
Tags:
Comments
-
Thank you, that worked
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!