search text keywords and return count

[PrashanthKumar123]

hi - I have a list of keywords. I am looking for a formula that counts the number of matched keywords in each row of the input data. I've tried Search but running into issues.

For e.g.,

If keyword list is "Apple", "Ball, "Cat", "Family"

Row 1: Apple Devil Egg Person
Row 2: Success Right Wrong Sorry
Row 3: Hi Ball Family Hello

My output should be
Row 1: 1
Row 2: 0
Row 3: 2

Thanks in advance!

 

[mrshl9898]

=COUNT(MATCH({"Apple","Ball","Cat","Family"},A1:D1,0))

 

[PrashanthKumar123]

hi - thanks for the help! This doesn't seem to work. To clarify, this is my spreadsheet with the input, expected output and the keyword list.

Input	Expected Output
Apple Devil Egg Person	1​
Success Right Wrong Sorry	0​
Hi Ball Family Hello	2​
Keywords
Apple
Ball
Cat
Family

 

[PrashanthKumar123]

hi - this seems to working with Count(Search()) formula. thanks for the help again

 

[Aladin Akyurek]

hi - I have a list of keywords. I am looking for a formula that counts the number of matched keywords in each row of the input data. I've tried Search but running into issues.

For e.g.,

If keyword list is "Apple", "Ball, "Cat", "Family"

Row 1: Apple Devil Egg Person
Row 2: Success Right Wrong Sorry
Row 3: Hi Ball Family Hello

My output should be
Row 1: 1
Row 2: 0
Row 3: 2

Thanks in advance!

is "Apple Devil Egg Person" in a single cell, say in A1, or 4 cells, say in A1:D1 ?