Countifs with <> Value

06/29/20
Accepted

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

Best Answers

  • Accepted Answer

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

    Thanks Again.

Answers

  • Accepted Answer

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

    Thanks Again.

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Happy to help. 👍️

    thinkspi.com

Sign In or Register to comment.