Insert count based on word in another cell.

[Rick187]

Hi,


I would like to get the total count based on a word that is contained somewhere in another column.


For example:


If the value of columnA contains the word from ColumnB then insert count


If I have the following 4 values in column A


//SRS4567
//SRS456232
//QBR22221
//FRA1111


In Column B, I have the following values


SRS
QBR


In Column C, next to "SRS", I would like it to display "2" because in Column A two of the cells contain the word "SRS" somewhere in the cell. Next to QBR, I would like it to display "1" because the letters "QBR" has only been mentioned once in column A.


Does anyone know which formula is needed for this?


Any help would be appreciated.


Thanks in advance.

 

[FormR]

Hi, you could try this.

Excel 2013/2016
	A	B	C
1	//SRS4567	SRS	2
2	//SRS456232	QBR	1
3	//QBR22221
4	//FRA1111
Sheet1

Cell Formulas
Range	Formula
C1	=COUNTIFS(A:A,"*"&B1&"*")

 

[AlanY]

try

=COUNTIF(A:A,"*"&B1&"*")

assuming SRS etc started in B1