Countifs same column different criteria

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

Find more posts tagged with

Formulas

Legal

Project Management

Comments

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Countifs result not matching filter
In my sheet, I have a filter for 2 values (see below images). The result is 294 In my report this formula yields 304. =COUNTIFS({helper-child}, "1", {gapStatus}, <>"Rejected (not a GAP)", {gapStatus}, <>"removed - duplicate", {gapStatus}, <>"removed - not valid") Why are they not matching? What am I missing?
Using CONTAINS in a MAX(COLLECT) function
I have a schedule that has a task name column, a date column and a task type column. I am trying to build a formula (in another sheet) that will return the latest date based on when the task type is "APP" and the task name contains "GS" somewhere in the cell. Here is the formula I have come up with: MAX(COLLECT({Schedule…