Forum Discussion
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(A4:A437, "ai"). The individual cells
in the range sometimes contain multiple search words like "ai replace photo editor". The data is not clean in
that respect. When I use the search tool in the top right of the screen and type in "ai," it finds every occurrence,
but I can't count and display them in a cell automatically.
When I use the CountIf function the result is always "1". I've tried COUNTIFS and get the same result.
I've attached some sample data here. Why does it work in "Search" and not in "COUNTIF"?
| =COUNTIF(A3:A100, "ai") | |
| Negative keyword | Keyword or list |
photoshop online free editing | Keyword |
| how to photograph hats for ecommerce | Keyword |
| blur photo to clear photo website | Keyword |
| analyse photo en ligne | Keyword |
| replicate delivery photo | Keyword |
| سایت زیبا سازی عکس | Keyword |
| برنامه ادیت عکس با هوش مصنوعی | Keyword |
| حذف اشیا از عکس آنلاین | Keyword |
| هوش مصنوعی بازسازی عکس | Keyword |
| ai photo blur remover free | Keyword |
| سایت هوش مصنوعی عکس | Keyword |
| ادیت عکس با هوش مصنوعی انلاین | Keyword |
| ترمیم عکس قدیمی با هوش مصنوعی | Keyword |
| snapedit photo enhancer | Keyword |
| ai replace photo editor | Keyword |
| ai for edit photo | Keyword |
| ai photo editing background | Keyword |
| blur to clear image ai | Keyword |
| restorephotos io | Keyword |
| ai photo correction free | Keyword |
| ai edit pic | Keyword |
| ai outpainting | Keyword |
| make pictures clear | Keyword |
| ai photo remover | Keyword |
| unblur pictures online free | Keyword |
| تحسين صور بالذكاء الاصطناعي | Keyword |
| auto focus photo | Keyword |
| erase object from photo online | Keyword |
| remini online | Keyword |
| image blur remover | Keyword |
| ai remove text from image | Keyword |
| clear photo quality online | Keyword |
| ai image enhancer | Keyword |
| ai retouch | Keyword |
| photo face clean | Keyword |
| retouch academy panel | Keyword |
| object remover | Keyword |
| remove object from photo online free | Keyword |
| ai image | Keyword |
| remove image from photo | Keyword |
| unblur image | Keyword |
| editor de imagen online | Keyword |
| توضيح الصور اون لاين | Keyword |
| Pronunciation | Keyword |
| clear blurred image | Keyword |
| remove text from image | Keyword |
| nettoyage photo | Keyword |
| photo clear | Keyword |
| fotor com | Keyword |
| online retouch photo | Keyword |
| photo enhancer | Keyword |
| Diy | Keyword |
| Do-it-yourself | Keyword |
| Lesson | Keyword |
| Tool | Keyword |
| Do It Yourself | Keyword |
| History | Keyword |
| Hiring | Keyword |
| Job | Keyword |
| face object remover | Keyword |
| ترمیم عکس قدیمی آنلاین رایگان | Keyword |
| ai remove text from picture online free | Keyword |
| سایت ادیت عکس با هوش مصنوعی | Keyword |
| ai dress remover website | Keyword |
| airbrush ai photo | Keyword |
| imagin ia | Keyword |
| make blurry photo clear online free | Keyword |
| ai beauty photo | Keyword |
| replicate com photo | Keyword |
| remove blur from image ai | Keyword |
| ai photo text enhancer | Keyword |
| ai bg object remover | Keyword |
| photoeditor ai | Keyword |
| سایت ادیت خودکار عکس | Keyword |
| ai photo recovery | Keyword |
| make my photo talk free | Keyword |
| editar cara en fotos | Keyword |
| subir calidad de imagen online gratis | Keyword |
| ai photo face enhancer | Keyword |
| ai photo fixer | Keyword |
| pic cleaner online | Keyword |
| ai picture editor | Keyword |
| fix out of focus photo | Keyword |
| image cleaner online free | Keyword |
| mejorar la calidad de una foto online | Keyword |
| سایت fotor | Keyword |
| old photo color restoration online free | Keyword |
| clear photo online free | Keyword |
| remove person from photo online free | Keyword |
| remove text from picture online free | Keyword |
| beautify photo online | Keyword |
| remove blurriness from photos | Keyword |
| mejorar calidad de imagen | Keyword |
| Occupations | Keyword |
| sites para editar fotos gratis | Keyword |
| clean up pictures | Keyword |
| enhance photos | Keyword |
You may try
=COUNTIF(A2:A100, "*ai *")space here is to separate "ai " from ai within some words
You may try
=COUNTIF(A2:A100, "*ai *")space here is to separate "ai " from ai within some words
- Thank you Sergei! The asterisks work beautifully. Problem solved.
While we're at it, I have another question. You can see in the sample data that there are instances of non-Latin script, I think Arabic and Chinese. Can Excel filter out or count data by the script used? I would like the ability to count the number of these instances, filter them out, or completely delete them.If you'd like filter them
- apply filter to entire range
- Text filter -> Custom filter -> is greater than "z"
- to delete select filtered rows, delete rows from right-click menu
- clear filter
