CountIF to look for a partial piece of text

Jack Parry

Hi all,

I'm looking to use Count IF to look for piece of a text from a different sheet.

I've tried the following variations with no luck:

=COUNTIFS({QA WORKLOAD Date}, "BACKLOG", {QA WORKLOAD Com/CT}, "COM", {QA WORKLOAD WO ST}, "99", {QA WORKLOAD Description}, CONTAINS("SUB", @cell}))

=COUNTIFS({QA WORKLOAD Date}, "BACKLOG", {QA WORKLOAD Com/CT}, "COM", {QA WORKLOAD WO ST}, "99", {QA WORKLOAD Description}, HAS({QA WORKLOAD Description}, "Trial"))

I'm missing something, but not sure what.

Thanks,

Jack

Michael Culley

=COUNTIFS({QA WORKLOAD Date}, "BACKLOG", {QA WORKLOAD Com/CT}, "COM", {QA WORKLOAD WO ST}, "99", {QA WORKLOAD Description}, CONTAINS("SUB", @cell}))

That one should work but you have a typo, you have a } after @cell

Michael Culley

=COUNTIFS({QA WORKLOAD Date}, "BACKLOG", {QA WORKLOAD Com/CT}, "COM", {QA WORKLOAD WO ST}, "99", {QA WORKLOAD Description}, CONTAINS("SUB", @cell}))

That one should work but you have a typo, you have a } after @cell