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
-
Hi @JP Pedicino
Hope you are fine, please try the following formula:
=COUNTIF({Import RFI's Range 1}, CONTAINS("ADCVD",@cell))
bassam.khalil2009@gmail.com
☑️ 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"
Answers
-
Hi @JP Pedicino
Hope you are fine, please try the following formula:
=COUNTIF({Import RFI's Range 1}, CONTAINS("ADCVD",@cell))
bassam.khalil2009@gmail.com
☑️ 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"
-
Thank you so much for your assistance!
-
You are welcome and i will be happy to help you any time.
bassam.khalil2009@gmail.com
☑️ 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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!