Count + Contains formula question



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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!