COUNTIF for a word within a phrase

Nanaia

Board Regular
Joined
Jan 11, 2018
Messages
227
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
I'm trying to count the number of times a word appears within a phrase. Each row lists an action taken by an agent (i.e. Policy: Transfer / Sellers). I'm trying to use COUNTIF to count how many of the row contain a specific word, like "Transfer" but it keeps giving the result as zero. I tested it and if "Transfer" is the only word in the cell it counts like I want it to. How do I get it to search the entire cell and pick out the word I'm trying to count when it doesn't show up the same number of characters from the left/middle/right in every occurence?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
47,895
Office Version
  1. 365
Platform
  1. Windows
If I understand correctly, how about
=COUNTIF(J:J,"*Transfer*")
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Watch MrExcel Video

Forum statistics

Threads
1,112,799
Messages
5,542,574
Members
410,560
Latest member
1ndependent
Top