How to use multiple NOT in cross reference formula

Gunjan Agicha

Hi,

I am implementing a formula which is taking cross reference from another sheet, let the column I am using be Column1, Let it have 10 different values. I want to get the count from this column where the value is not String1 and not String 2. I didn't find any usage with multiple nots, can somebody help?

Genevieve P.

Hi @Gunjan Agicha

With a COUNT function, you'll need to use a COUNTIFS (plural, with an S), to identify that there are multiple criteria you're looking (or not looking) for. Then you can use <> to indicate "not".

Try something like this:

=COUNTIFS({Column 1 Reference}, <> "String 1", {Column 1 Reference}, <> "String 2")

Let me know if this makes sense or if you need any additional help! If you need more help, it would be useful to know what you tried (copy/paste the formula) and to see any screen captures of the source sheet (but please block out any sensitive data).

Cheers,

Genevieve