Forum Discussion
DavidJ2210
Jul 31, 2024Copper Contributor
Find in document working but COUNTIF is not.
Hi Community, I am exporting keyword data out of Google Ads into Excel. I am trying to use the countif function to count the number of occurrences of specific search words like "AI." =COUNTIF(A...
- Jul 31, 2024
You may try
=COUNTIF(A2:A100, "*ai *")
space here is to separate "ai " from ai within some words
DavidJ2210
Copper Contributor
SergeiBaklan
Aug 01, 2024MVP
DavidJ2210 , you are welcome