Hi all, anyone can solve this question?

Suppose I have two lists, namely WordList1 and WordList2, each containing some keywords I defined. For example, abc1, abc2, ... and abc5 belongs to WordList1

I want to write an excel function to count how many occurrence of keywords from the same group appears.

For example, "abc1 abc1 iiiiijjjkkkk" countains two "abc1", therefore WordCount1 (refer to WordList1) is 2.

f.JPG