Count + Contains formula question

Hello!
I'm having trouble with a formula in a sheet summary field.
I have a column called "Service Type" where I want to count the number of entries that contain QA. There are multiple QA entries, some say QA+, some say QA5, QA10 or QA20, QA25, etc. to give you an idea. The common denominator is the QA, so I want to use it to count how many QA entries there are in that column.
=(COUNTIF(CONTAINS([Service Type]:[Service Type], "QA")))
I get an error message of #INCORRECT ARGUMENT SET, so I've done something wrong. I'm just not sure what. Hoping someone may have some ideas.
Thank you!
Best Answer
-
Your syntax just needs adjusted is all.
=COUNTIF([Service Type]:[Service Type], CONTAINS("QA", @cell))
Answers
-
Your syntax just needs adjusted is all.
=COUNTIF([Service Type]:[Service Type], CONTAINS("QA", @cell))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 151 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!