Count + Contains formula question

Kelly Ospina

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!

Paul Newcome

Your syntax just needs adjusted is all.

=COUNTIF([Service Type]:[Service Type], CONTAINS("QA", @cell))

Paul Newcome

Your syntax just needs adjusted is all.

=COUNTIF([Service Type]:[Service Type], CONTAINS("QA", @cell))