Countifs with <> Value

Abir Mannan · 06/29/20

i am using this to count the number of the "Brand Content" from that column "CCMS Range 2" also when it is not completed. Getting #UNPArseable msg.

I am new to this, not sure if i am missing any syntax.

=COUNTIFS({CCMS Range 2}, <>"Brands Content",[{Ticket Status},"120 - Completed - Project Closeout")

Thanks

Paul Newcome · 06/30/20

The problem is the opening square bracket just before the second range. Try removing that and see if it works.

Abir Mannan · 06/30/20

It worked. thanks. It was auto adding when I moved to the second part, deleting that worked great.

Thanks Again.

Paul Newcome · 06/30/20

The problem is the opening square bracket just before the second range. Try removing that and see if it works.

Abir Mannan · 06/30/20

It worked. thanks. It was auto adding when I moved to the second part, deleting that worked great.

Thanks Again.

Paul Newcome · 06/30/20

Happy to help. 👍️

Best Answers