COUNTSIFS does not Contain

RingJake

Hello,

I've put together the following formula, to count certain items in a different sheet that don't meet certain criteria, please see below.

=COUNTIFS({SE-Region}, Region@row, {Status}, <>"Completed", {Status}, <>"Canceled", {Status}, <>"Duplicate", {Summary}, <>CONTAINS("Onboarding", {Summary}))

The formula works until the "{Summary} ("Onboarding", {Summary})), so I'm not sure why this isn't taking.

The answer is outputting "0" to me and the formula is not taking, which I know is not true. Is there anything wrong with my syntax?

Paul Newcome

Try this...

=COUNTIFS({SE-Region}, Region@row, {Status}, <>"Completed", {Status}, <>"Canceled", {Status}, <>"Duplicate", {Summary}, NOT(CONTAINS("Onboarding", @cell)))

RingJake

Excellent, thank you!

RingJake

Hi @Paul Newcome, having difficulty with a very similar formula, but can't get it to work. Can you please see if there is any syntax that is off here as well?

The formula takes, but the count if 0 for everything I am applying this to.

=COUNTIFS({Carrier}, CONTAINS([Carrier Report Link]@row, {Carrier}), {Status}, <>"Completed", {Status}, <>"Canceled", {Status}, <>"Duplicate", {Summary}, NOT(CONTAINS("Onboarding", {Summary})))

Thank you!

Paul Newcome

You need to use "@cell" references within the range portion of the CONTAINS functions.

RingJake

Hi @Paul Newcome,

I've tried this but still do not get any responses. Is this what you mean?

=COUNTIFS({Carrier}, CONTAINS([Carrier Report Link]@row, {Carrier}), {Status}, <>"Completed", {Status}, <>"Canceled", {Status}, <>"Duplicate", {Summary}, NOT(CONTAINS("Onboarding", @cell)))

Paul Newcome

Yes, but you need that in each of the CONTAINS functions. Your first one still needs the @cell reference.

RingJake

Ah, I see. Perfect, thank you!

Paul Newcome

Happy to help. 👍️