Count Number of Cells that Contain Certain Text?

Genevieve P.

Hey @Irene Dee

Sure! You can use <> to indicate "does not equal" and then use CONTAINS to search for CMC:

=COUNTIFS(Document:Document, 1, Discipline:Discipline, <> CONTAINS("CMC", @cell), Status:Status, "Not Started")

Irene Dee

@Genevieve P.

For some reason I'm getting an #INVALID OPERATION message now. Any ideas the cause?

Thanks!

Genevieve P.

Hi @Irene Dee

My apologies! We need to use NOT() around Contains, instead of <>

=COUNTIFS(Document:Document, 1, Discipline:Discipline, NOT(CONTAINS("CMC", @cell)), Status:Status, "Not Started")