COUNTIF EXCEPT

Hello, could you help me find a formula that counts all except "x".

I have a Column that has data such as: dates, "ok" and "N/A". I try using the Countif formula but cant seem to figure how to have it count all except the "N/A" information.

I´d appreciate the help.

Thank you!

Find more posts tagged with

Construction

Formulas

Comments

Brian W

You could use COUNTIFS with OR to count everything that is either a date or text, and NOT to not count the "N/A" cells:

=COUNTIFS([Column Name]:[Column Name], OR(ISDATE(@cell), ISTEXT(@cell)), [Column Name]:[Column Name], NOT(@cell = "N/A"))

Andrée Starå

Hi Elena,

Try something like this.

This formula might work but it depends on what is included in your column.

=COUNTIF([Column Name]:[Column Name]; <>"N/A")

The same version but with the below changes for your and others convenience.

=COUNTIF([Column Name]:[Column Name], <>"N/A")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Would that work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Pam Grant

I want to count all rows with the [assigned to] person except where the [customer declined] box is checked.

This formula gives me an "Invalid Operation"

=COUNTIFS({520.07db Qualified Testing Facility Databa Range 1}, [Master Planner]@row, NOT({520.07db Qualified Testing Facility Datab Range 11} = 1))

Andrée Starå

@Pam Grant

Hi Pam,

You just need to change the end of your formula to:

=COUNTIFS({520.07db Qualified Testing Facility Databa Range 1}, [Master Planner]@row, NOT({520.07db Qualified Testing Facility Datab Range 11},0)

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.