Forum Discussion

DavidJ2210's avatar
DavidJ2210
Copper Contributor
Jul 31, 2024

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...
  • SergeiBaklan's avatar
    Jul 31, 2024

    DavidJ2210 

    You may try

    =COUNTIF(A2:A100, "*ai *")

    space here is to separate "ai " from ai within some words

Resources