COUNTIF formula with CONTAINS not working

JP Pedicino

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.

Bassam Khalil

Hi @JP Pedicino 

Hope you are fine, please try the following formula:

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

Bassam Khalil

Hi @JP Pedicino 

Hope you are fine, please try the following formula:

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

JP Pedicino

Thank you so much for your assistance!

Bassam Khalil

@JP Pedicino

You are welcome and i will be happy to help you any time.