COUNTIF formula with CONTAINS not working

I am having an issue when adding a "contains" function to my "countif" function. I am hoping someone can assist.

The current formula that I am using works perfectly for COUNTIF

=COUNTIF({Import RFI's Range 1}, "ADCVD")

When I convert the formula to include CONTAINS I get an INVALID ARGUMENT message.

=COUNTIF(CONTAINS({Import RFI's Range 1}, "ADCVD"))

I've tried a couple of different variations of the formula, but can't seem to get it right.

I would appreciate if anyone can assist.


Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Answer ✓

    Hi @JP Pedicino 

    Hope you are fine, please try the following formula:

    =COUNTIF({Import RFI's Range 1}, CONTAINS("ADCVD",@cell)) 

    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!